Trying to get highest value for a dimension in a KPI

acholchemit — Mon, 20 Dec 2021 21:08:46 GMT

I have a table of data that looks like the following;

Customer, Visit Duration

123, 60

123, 45

456, 50

789, 30

789, 50

789, 20

I am trying to put in a KPI the highest count of rows or entries by Customer. I have seen a few similar examples of this but so far I haven't been able to get this working.

This is what I have so far which as I say doesn't work.

FirstSortedValue([Customer Number], -Aggr(Count({$<[Customer Number]-={},[Visit In Year To Date]={"-1"}>}[Customer Number]), [Customer Number]))

Any help appreciated.

Re: Trying to get highest value for a dimension in a KPI

acholchemit — Tue, 14 Apr 2020 08:58:00 GMT

I think that I may have solved this by using the following code

Max( Aggr(Count({$<[Customer Number]-={''},[Visit In Year To Date]={"-1"}>}[Visit Entry Number]),[Customer Number]))

topic Re: Trying to get highest value for a dimension in a KPI in App Development

Trying to get highest value for a dimension in a KPI

Re: Trying to get highest value for a dimension in a KPI