Hi Mohammed present I don't have data.
I need output like below straight table.
IssuesId Previous_status Current_status IssuesIdcount date
11 closed open 1 01/01/18
22 closed open 1 02/01/18
33 closed open 1 03/01/18
But I don't have Previous And current status fields.I have stuts field an
If user select any two dates and compare those two dates one is min and one is max date calculate issues id when status changed close to open.
If user select 01/01/18(mindate) and 03/01/18(maxdate).if issuesid 11, 01/01/18 status is closed and same issuesId11 03/01/18 status changed to open Than calculate the issueId.