topic Re: Get Dimension with Highest Value in App Development

Get Dimension with Highest Value

Anonymous — Wed, 13 Jun 2018 09:44:57 GMT

Hi,

I want to show the date with has the highest total sum of amount in a KPI , does anyone know how.

Amount Date

Thanks

ogautier62 — Wed, 13 Jun 2018 11:18:44 GMT

Hi,

create a sheet with Date in dimension,

and in expression :

if(sum(kpi) = max(total aggr(nodistinct sum(kpi),date)),date)

date with the max sum kpi will appear

regards

sunny_talwar — Wed, 13 Jun 2018 11:22:33 GMT

May be this

FirstSortedValue(Date, -Aggr(Sum(Amount), Date))

Anonymous — Thu, 14 Jun 2018 04:44:51 GMT

Thanks, have previously seen your answer elsewhere and tried it.

Realized that my output was not in date format.

Total carelessness on my side.

ogautier62 — Thu, 14 Jun 2018 17:44:09 GMT

Yes!!!!

I made a copy paste of your text

Replace And with, (comma)

And Maxstring in place of max for a string

Naushad07 — Mon, 23 Dec 2019 15:43:58 GMT

I am using a similar formula. It works fine without '-'(minus) sign, but when I'm using a minus sign, I am not getting any value.

I used the same formula for Table and it works, but I'm not getting any values for a KPI.