topic Re: Top dimension values in tables in App Development

Top dimension values in tables

thakurj — Thu, 15 Feb 2024 07:48:46 GMT

Hi,

Is it possible to make the top values of a certain dimension in a table based on multiple measures.

Ordinarily, the top values of the dimension are based on the first measure. I want the user to be able to choose the measure on which the top values of the dimension should be based.

eg. with a click of a button, the user should be able to toggle between top 10 products with highest sales and top 10 products with highest profit.

Re: Top dimension values in tables

theoat — Thu, 15 Feb 2024 08:12:09 GMT

Hello
Yes, this is available by doing set analysis in your measurements. Inside it, you can select the top 10 of the dimension according to the chosen metric (depending on the button clicked, the value of the variable differs).
I can possibly give you a little demonstration with an easy use case.

Kind regards
Theo ATRAGIE.

Re: Top dimension values in tables

thakurj — Thu, 15 Feb 2024 08:18:10 GMT

@theoat Could you please show the demonstration with the use case

Re: Top dimension values in tables

theoat — Thu, 15 Feb 2024 09:58:51 GMT

First, create a variable with an initial value of 0.

Next, add two buttons. One for your first metric (Turnover), and one for your second (Sales Volume). Clicking the first button sets the variable to 0. Clicking the second button affects the value 1.

Next, make a conditional measurement. Depending on the value of the variable, this will be one measure or the other that will be calculated.

Next, add your dimension, and add the top 10 limitation.

And voila, the graphic adapts to the button clicked.

Top 10 products by Turnover :

Top 10 products by Sales volume.

Kind regards,
Théo ATRAGIE.