topic Re: Set Analysis in App Development

Set Analysis

pratham39 — Fri, 14 Oct 2022 18:48:40 GMT

In ID = 1A there are two DOA Values,

that's why count (where difference of DOE-DOA less than 0) is coming 2 ,

Actually there should be 1 because that is only 1 ID which is 1A but due to two different dates ,

count is coming 2,

In KPI also I want to achieve same result that count should be 1.

Anyone can help?

Thanks

BrunPierre — Fri, 14 Oct 2022 20:28:56 GMT

Perhaps as below

FirstSortedValue(Aggr(Count(ID),ID,DOE,DOA), -DOA)

pratham39 — Sat, 15 Oct 2022 13:06:18 GMT

Hi Sir,

First of all thanks for your response,

i want to display Count 1 when DOE - DOA <0 for ID = 1A, overall KPI Value should be 3 bcz there are 3 ID's

Please help

Thanks

BrunPierre — Sun, 16 Oct 2022 11:34:09 GMT

=Count(Aggr(FirstSortedValue(ID,-DOA),ID,DOA,DOE))