Currently I made 3 different radar charts, but would like to make them to one chart by overlapping display.
For values, I added the below calculated fields.
distinct_count(id)/min(distinctCountOver(id,,PRE_AGG))
distinct_count(id)/sum(distinct_count(id,[{staff_name}]))
distinct_count(id)/min(distinctCountOver(id,[{staff_name}],PRE_AGG))
I’d appreciated it if someone could help me on this.
Hhi @Sunny
first option would be to bring all measures into the value area. If that will not work, you could overlay all three chats to make it look like one chart.
BR
Hi @ErikG
Thank you so much for your advice!
It seems I cannot bring multiple measures in the value area.
Also, if possible I’d like to use filters for the charts. So if I overlay by using free-form, I can’t see the visuals sorted by the filter when they are placed in the backward.
Hi @ErikG
Currently the chart order is as follows.
Front: Kind_percent
Middle: Shopname
Back: Staffname
When I use staff_name filter for the staffname chart, it only shows the front chart: Kind_percent (Remain unchanged)