I have fields id and issue_creationdate and taregetdate
Id Issue_creation_date. Tareget_date
1. 07/10/2018. 07/15/2018
1 . 07/10/2018. 07/14/2018
2. 07/09/2018. 07/09/2018
3. 07/09/2018. 07/11/2018
3. 07/09/2018. 07/10/2018
My requirement is count issue id the when target date is changed.
Example above table id 1 first target date 07/14/2018 but that id target date change to 07/15/2018.
So I need calculate issues id intial one targetdate and changed to another date.
How to write the expression? Please help on this.
So, do you want the minimum of target date within the id?
you're right, If the records changed, there are several row for the same ID, no need track the dimension change
I think it's sufficient only count the ID, not the ID&Target date, because the latter is different within ID.
Yes it is kpi. But your expectation not working.
The above table id 1and 3 target date is changed. So my issue id count is 2.
Just count the issues id when target date is changed.
The answer should be:
=count(distinct ID)-sum(if(Aggr(count(ID), ID)>1,1,0))
So count the individual ID-s, and subtract from that count, where duplication in ID.