Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have a table with accounts and respective sales transactions (i.e. several sales line items for a specific account).
I would like to compare each account in a box plot (that I know how to do), but also against the overall country average / quartiles, etc.
Thank you for your help.
JM
If Country is a dimension in your chart, you can use the TOTAL qualifier to "widen" your dimension like this:
avg({$<Account=>} TOTAL<Country> Sales)
If Country if not in your chart, you will need to use Aggr() instead of TOTAL.
aggr(avg({$<Account=>} Sales), Country)
if you have more than one Country linked to your chart dimension, you will need to add an outer aggregation to aggregate the multiple values. For example:
Avg(aggr(avg({$<Account=>} Sales), Country))
-Rob