second most repeated value

[Paco]

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]

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

[Paco]

in summary, the load is:

LOAD

ID,

CATEGORY,

FRUIT

FROM QVD FILE

[sunny_talwar]

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

[Paco]

in the dashboard display. creating a chart table

[Paco]

up

[sunny_talwar]

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?