Hi Shivesh please help on this if you have any idea.
I need help for the below requirement.I attached one sample Excel data above.
-------------------------------------------------------
Fields in my table are
table A:
Issue_ID Issue_status Date_Upload Tareget_date Action_ID Action_status
--------------------------------------------------------------------------------------------------------
Requirement 1:
count the ID's for newly opened status.
In the above table i have issue_status and date_upload fields.
->KPI chart by default in the date_upload field we need to compare maximum_date and maximum previous date.if maximum previous date status is draft and maximum date status is open then count the issue_id's.
->On the same KPI chart if the user selects any two dates compare those two dates(ex:the dates are 01-01-2018 to 10-01-2018.if the user selects 02-01-2018 and 06-01-2018 in these date 02-01-2018 is minimum and 06-01-208 is maximum. we need to compare those two dates no need to compare between dates)if minimum date satus is draft and maximum date status is open then count the issue_id's.
example:
01-01-2018
02-01-2018
03-01-2018
04-01-2018
05-01-2018
06-01-2018
max date= 06-01-2018
max previous date=05-01-2018
if user selects dates 02-01-2018 and 05-01-2018 then 02-01-2018 is minimum and 05-01-2018 is maximum.
---------------------------------------------------------------------------------------------------------------------------------
Requirement 2:
count the ID's for closed status.
same as requirement 1 but maximum previous date status is open and maximum date status is closed then count the issue_id's.
-------------------------------------------------------------------------------------------------------------------------------------
Requirement 3:
target date changed count the ID's.
In the above table i have Taget_date and date_upload fields.
->KPI chart by default in the date_upload field we need to compare maximum_date and maximum previous date.if maximum date and maximum previous dates in the Taget_date field are different then caluclate the count id's.
->On the same 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.
Example:
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-03-2018 then count is 2 because id 01,03 target dates are changed and id 02 target dates are not changed.
I need quires for the above requirements in the back-end level.
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.
Thanking you.
