Hi,
I want to present sub reason of total gv% on filled map based on zip code. I did a calculation: percentOfTotal(sum({gv_count})) to get the % of gv. However, if I add group by on this formula (either group by zip code or sub reason), it is not working. I think it is because I only selected zip code for location and there is no other category for sub reason at all. Is there any way to solve this? (It works for the pivot table)
What error are you getting?
Even when you group it by zip code it’s not working?
If you group it by zip code it should be 100% on all zip codes.
So for this calculation, if I group by zip code; the map chart will be all 100% but if i group by sub reason, it said: table attribute calculation is missing
Yes you need to reference any field you are using in your percent of total in your visual.
You could look to do it a separate way by dividing based on groups.
sumOver({gv_count},[{sub_category}],PRE_AGG)/sumOver({gv_count},[{zip_code}],PRE_AGG)