topic Re: second most repeated value in App Development

second most repeated value

Paco — Thu, 03 Oct 2019 11:56:14 GMT

HELLO,

I am creating a table on my board. I need to create three columns with the 3 dimensions that best suit.

I need this:

Category	count	category(most repeated)	Category(second more repeated)	Category(third more repeated)
Fruit	200	apples	oranges	strawberries

I am getting the following:

Category	count	category(most repeated)	Category(second more repeated)	Category(third more repeated)
Fruit	150	apples	-	-
Fruit	40	-	oranges	-
Fruit	10	-	-	strawberries

Thanks!

sunny_talwar — Thu, 03 Oct 2019 11:11:07 GMT

Where and how are you creating this? Can you share Script/expression you are using?

Paco — Thu, 03 Oct 2019 11:54:00 GMT

in summary, the load is:

LOAD

ID,

CATEGORY,

FRUIT

FROM QVD FILE

sunny_talwar — Thu, 03 Oct 2019 12:01:58 GMT

Okay, but where do you perform this transformation which doesn't work for you?

Paco — Thu, 03 Oct 2019 13:33:27 GMT

in the dashboard display. creating a chart table

Paco — Fri, 04 Oct 2019 11:50:54 GMT

sunny_talwar — Fri, 04 Oct 2019 12:16:18 GMT

I don't think you are answering what I am looking for, would you be able to share a sample to help you better here?