Handling a Interval Match to show ticket status

[Anonymous]

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

OUTPUT TABLE

Sample Data

---

Ticket ID	Created Date	Status Date	Status
ID1	12-24-18	12-25-18	Inprogress
ID2	12-24-18
ID3	12-22-18	12-24-18	completed
ID4	12-20-18	12-21-18	completed
ID5	12-20-18	12-20-18	completed
ID6	12-24-18	12-26-18	Hold

---

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

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

Best Regards,
Dale