How to compare numbers between rows in a table for specific dimension

pranaview — Tue, 26 Jul 2022 06:06:02 GMT

Hello,

I have a requirement where i have to check if the numbers for a group matches or not and based on that assign green/red color to the text in a straight table. Will be more clear from below example

Code Date Amount

1 7/10/2022 500

1 7/17/2022 500

2 7/5/2022 878

2 7/11/2022 880

3 7/20/2022 350

3 7/25/2022 350

So, in the above example, Amount on two different dates matches for Code 1 and 3 and hence all 4 rows corresponding to these 2 codes needs to be shown in Green (only Amount column in green is enough) and for Code 2, the Amount doesn't match and hence these two rows will be red. Hope the requirement is clear enough. I am looking to handle this in the front end table .

Any tip or suggestion will be appreciated, thanks.

Re: How to compare numbers between rows in a table for specific dimension

justISO — Tue, 26 Jul 2022 07:50:57 GMT

Hi, maybe

if(aggr(nodistinct count(distinct Amount),Code)=1, green(), lightred())

Re: How to compare numbers between rows in a table for specific dimension

pranaview — Wed, 03 Aug 2022 08:06:20 GMT

Hello, this expression worked. thanks!

topic Re: How to compare numbers between rows in a table for specific dimension in App Development

How to compare numbers between rows in a table for specific dimension

Re: How to compare numbers between rows in a table for specific dimension

Re: How to compare numbers between rows in a table for specific dimension