Sum - Group by - Order by

danimarc12 — Fri, 09 Dec 2022 15:14:03 GMT

Hello everyone!

I have an issue with my App. I want to wirte an expression which sums a value grouped by a field and then order it by a date field.

My sum expression is: Aggr(sum({<causale={0003}>}importo), datar) which is working.

Then I want to order these values by the date field datar (Data reg in the image) to display this value in a KPI box but I don't know how to do it. I've used this expression:

FirstSortedValue( Aggr(sum({<causale={0003}>}importo), datar), - datar)

but it's not working.

Could anyone suggest me the correct way to achieve that?

Thanks a lot!

Re: Sum - Group by - Order by

edwin — Sat, 10 Dec 2022 21:07:39 GMT

if datar is a dual (a date field), and you are using it as a dimension in your table, then sorting by this field first should be enough, you dont even need to sort by expression. it is curious though that you have two entries for 5/12/2022 which tells me either you arent using dater field as dimension (maybe its a calculation) or it may be some sort of time field - that 5/12/2022 has two numeric values.

you may need to add more info so others can understand whats going on

topic Sum - Group by - Order by in App Development

Sum - Group by - Order by

Re: Sum - Group by - Order by