Hi community. I have a few situations where I want to plot various things over a number of common metrics. As an example, image you have a set of retail stores and want to compare them across Sales / Traffic / Items Per sale.
Imagine that the way you want to look at this is to rank each store based on each metric.
A raw table might look like this:
Store
Sales
Rank
Traffic
Rank
IPS
Rank
Store A
100
6
50
3
2.6
3
Store B
200
4
30
7
2.8
2
I want to plot this as a Radar chart. Because a QS radar chart is based on two dimensions, I can't plot it by just setting the dimension to Store and adding lots of measures. I need to create a calculated dimension using valuelist.
So, I created a dimension using ValueList('Sales','Traffic','IPS'). And then created a measure called metrics like this:
But this doesn't give the desired result. In my example, I actually need the rank turned into a score, so the bigger number looks bigger on the chart. Any thoughts?
