Forum Discussion
Help needed with LookUp Table/List
To do that:
1. unpivot columns 2-4 in the query editor (just highlight your Customer Name column, right click on it, and choose unpivot other columns.
2. Load the table.
3. Get a Radar chart by hitting the ellipsis in the Visualization pane and choose Get More Visuals.
4. Put the Attribute column in the category field well and your value column in the values area (choose Count as the aggregation or provide your own measure).
5. Make a table visual with your Value column to show Very Good, Good, etc. to be used as a slicer.
This is what it will look like
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Thanks for your quick answer, but it seems that the Count function is not working with textfields.
it shows only the whole amount of the categories, not the separated (very good, good, bad) value