Re: second most repeated value

Paco · ‎2019-10-03

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 · ‎2019-10-03

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

Paco · ‎2019-10-03

in summary, the load is:

LOAD

ID,

CATEGORY,

FRUIT

FROM QVD FILE

sunny_talwar · ‎2019-10-03

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

Paco · ‎2019-10-03

in the dashboard display. creating a chart table

Paco · ‎2019-10-04

up

sunny_talwar · ‎2019-10-04

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?