if get any idea on below requirement please help on this.
I want do in back end level(script)
target date changed count the ID's.
I have table fields
-> KPI chart if the user selects any two dates compare those two dates.if maximum date and maximum previous dates in the Taget_date field are different then caluclate the count id's.
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
In the above table if we select dates in the date upload field i.e., 01-01-2018 and 03-01-2018 then count is 2 because id 01,03 target dates are changed and id 02 target dates are not changed.
so just count the Issues_ID when user select any two dates(ex:01-01-2018 is min date and 03-01-2018 is max date)compare those two dates if min date targetdate is onedate and max date targetdate is change to another date than caliculate the Issues_ID count.
I need quires for the above requirements in the back-end level.and write the expression front end level also if any simple way.
I have written quires in the front end level but the performance is slow and it is showing an error in the chart i.e., time out.