topic Re: FirstSorted showing value not at the needed row in App Development

FirstSorted showing value not at the needed row

Micki — Fri, 16 Oct 2020 13:50:03 GMT

Hi folks,

I have a very basic measure with firs sorted function,

sum(AGGR( IF(FirstSortedValue(DISTINCT LastResultOutcome, -TIMESTAMP(AnalyticsUpdatedDate)) = 'Failed', 1,0), Title))

It's working good but showing value not on the needed row so if you see instead of 0 should be 1.

Does it naturally for FirstSortedvalue or it's possible to change somehow?

Thanks

sunny_talwar — Fri, 16 Oct 2020 13:58:45 GMT

@Micki what all dimensions do you have in the chart? The row above should be 0, and the highlighted row should be 1?

Micki — Mon, 19 Oct 2020 09:26:38 GMT

sunny_talwar — Mon, 19 Oct 2020 17:59:27 GMT

@Micki Try this

If(FirstSortedValue(TOTAL <T1.TITLE> T2.OUTCOME, -T2.HISTORY) = 'Passed' and T2.HISTORY = Max(TOTAL <T1.TITLE> T2.HISTORY), 1,0)

Micki — Wed, 21 Oct 2020 12:44:31 GMT

thank you @sunny_talwar , based on your answer i edit a little bit measure and now it's working