topic Re: Display only the highest value row while grouping dimension in App Development

Display only the highest value row while grouping dimension

Santes8 — Sat, 16 Nov 2024 05:53:02 GMT

I am looking to group dimension values and display only the highest value row

From the attached example, how can I display only the row with 'InsurancePolicy...' equaling 2 by grouping the 'Total Charges' ?

Note, this is a very small subset example of a metric that would be used on a much larger scale.

Thank you!

Re: Display only the highest value row while grouping dimension

JordyWegman — Fri, 10 May 2019 07:50:23 GMT

Hi Santes,

Do you want the highest value per dimension value? Or just the highest value with the corresponding dimension?

First question will result in multiple rows, and the second will result in just one row.

Jordy

Climber

Re: Display only the highest value row while grouping dimension

Santes8 — Fri, 10 May 2019 13:57:40 GMT

Hi Jordy,
I am looking to display the entire row based on the the highest number in the one dimension, grouping another dimension.
(I would like it to look for all 99s in Total Charges then only display the entire row with the highest number in Insurance Policy...)
Thanks!