Hi,
I have a geo plot of the US and I want to show whether 7 customer segments are above/below average for each state, i.e. an index value.
I'd want to view these index values one segment at a time, i.e so using a quick filter I can select Segment 4 for example and it'll tell me which states this segment over/underindexes in.
The problem is that if I do it one at a time, my current calculation of COUNTD([UserID])/WINDOW_AVG([COUNTD([UserID])) won't work because the window is just that particular segment. This calculation only works when I've selected all segments.
I would really appreciate if you had any ideas on how to improve the above calculation or suggest an alternative method.
Thanks
J
5 answers
