Reply
Highlighted
Regular Visitor
Posts: 20
Registered: ‎09-13-2017
Accepted Solution

Handling a Interval Match to show ticket status

HI All

 

I have data like "Input table", I want to show No of Ticket Created, No of Ticket Closed, No of Ticket Opened based on Date selection. so I want to transform the "Input Table" to "Output Table" 

 

How can I achieve this transformation?

 

Note: if the status is not Completed then the status date should be today date (12/27/2018) and Status should be Open

 

INPUT TABLE

Input.png

 

OUTPUT TABLE

Output.png

 

Sample Data


Ticket IDCreated DateStatus DateStatus
ID112-24-1812-25-18Inprogress
ID212-24-18  
ID312-22-1812-24-18completed
ID412-20-1812-21-18completed
ID512-20-1812-20-18completed
ID612-24-1812-26-18Hold


Accepted Solutions
Community Support Team
Posts: 7,619
Registered: ‎05-02-2017

Re: Handling a Interval Match to show ticket status

Hi @vengadeshpalani,

 

There could be many solutions. I have created a solution based on your requirements. Please download the demo from the attachment. 

Handling-a-Interval-Match-to-show-ticket-status

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Attachment

All Replies
Community Support Team
Posts: 7,619
Registered: ‎05-02-2017

Re: Handling a Interval Match to show ticket status

Hi @vengadeshpalani,

 

There could be many solutions. I have created a solution based on your requirements. Please download the demo from the attachment. 

Handling-a-Interval-Match-to-show-ticket-status

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Attachment