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:
=pick(match(ValueList('Sales','Traffic','IPS'),'Sales','Traffic','IPS'),
Rank(Sum(SalesAmount)),
Rank(Sum(TrafficQty)),
Rank(Sum(SalesQty)/Count(Distinct OrderNumber))
)
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?