topic Use same Top 10 limit in a chart for the main and alternative measure in App Development

Use same Top 10 limit in a chart for the main and alternative measure

acholchemit — Mon, 20 Dec 2021 21:08:46 GMT

I have a chart and I would like to show two measures main and alternative but use the same Limit totals for both measures.

The measures would be

1. Total measure value (The limit total is based on this measure)

2. Average measure value

The effect would be we see the same Customers and be able to swap between the measures. In my chart this isnt working when I choose the alternative measure it loses the top 10 ranking and so shows a different set of Customers.

Is this possible?

Re: Use same Top 10 limit in a chart for the main and alternative measure

lironbaram — Tue, 14 Apr 2020 11:47:47 GMT

the built in top function always use the active dimension

for your requirement you can use a calculated dimension

aggr(if(rank(Total measure value)<=10,CustomerName),CustomerName)

Re: Use same Top 10 limit in a chart for the main and alternative measure

acholchemit — Tue, 14 Apr 2020 12:47:23 GMT

Worked like a charm, thankyou.