Example : you have Id and date and Targe_tdate.
Assume in date field having 3 months dates.01-jan -2018 to 31-Mar-2018.
If user select any two dates in this 3 months dates example 10-jan -2018 and 20-feb-2018 compare those two dates 10 and 20 not in-between dates only 10 and 20 and compare those two dates. if date 10-jan-2018 target date is one 20-feb-2018 targetdate changes than count the the IDs.
it means what are the id's target date change in those two days than count the ids .
Thanks, but it is still confusing.
So this the base data set:
Issue_ID Date_upload Target_date
01 01-01-2018 10-05-2018
01 03-01-2018 15-05-2018
02 01-01-2018 10-05-2018
02 03-01-2018 10-05-2018
03 01-01-2018 10-05-2018
03 03-01-2018 16-05-2018
When I select in Date_upload a date, like 01-01-2018 what is the desired output?
Count of ID (=3)? What means the duplicate ID?
Could you provide a simple example based on your table with inputs - outputs?
Not sure if this would work....
Issue_ID as IssueID,
if(Target_date<>peek(Target_date), Previous(Issue_ID)) New_IssueID
Order by Issue_ID;
Drop table YourTable;
and in front end use expression as
It is problem to drop the first table because of I am using first table for another kpis.
so without drop the first table how to write the expression.
and we need to some filter conditions like
Business=operations and status = open.
than load the id and date and targetdate fields and write the expressions.