Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Where and how are you creating this? Can you share Script/expression you are using?
in summary, the load is:
LOAD
ID,
CATEGORY,
FRUIT
FROM QVD FILE
Okay, but where do you perform this transformation which doesn't work for you?
in the dashboard display. creating a chart table
up
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?