Hi Chaitanya ,
Please create fields like below:
'closed' as Previous_status,
From Table SSS Where wildmatch(originalStatus,'closed');
'Open' as Current_status,
From Table SSS Where wildmatch(originalStatus,'Open');
let me know if any further clarification.
Hi Arvind thanks for your reply.
I will try the above script.
But my requirement is user select any two dates in filters and compare the those two dates count the issuesids based on previous status is closed and changed to open than count the issuesId.
I have one month data and fields are IssuesId and IssuesStatus and date.
and I am creating straight table add the IssuesId previousstatus currentstatus countof Issuesid
if user select two dates in filters like 10/jan/18 and 12/jan/18 .and compare 10 and 12 dates what are the issuesids status is closed in date 10 and changed to status open in 12 than count the issuesId.