Forum Discussion
Compare Opened & Closed Tickets
Hi There!
I want to compare how much tickets opened and closed per date. See example below:
My data looks like this:
Does someone has a good solution for this?
Greets!
Hi Anonymous ,
First you need to create a seperate calendar table
Table 2 = CALENDAR(DATE(2019,9,27),DATE(2019,9,30))Then try the following measures
Measure = COUNTROWS(FILTER('Table',[ClosedDate]=MAX('Table 2'[Date])))Measure 2 = COUNTROWS(FILTER('Table',[CreatedDate]=MAX('Table 2'[Date])))I filled in the dummy data you gave, so the result may be different. You can check more details from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- mwegener
Most Valuable Professional
Hi Anonymous ,
you should have date and time in separate columns.
Then connect the two date columns with a date table.
Create a measure for opened and closed tickets (COUNTROWS) and activate the corresponding connection to the date table with the function USERELETIONSHIP. Hi Anonymous ,
First you need to create a seperate calendar table
Table 2 = CALENDAR(DATE(2019,9,27),DATE(2019,9,30))Then try the following measures
Measure = COUNTROWS(FILTER('Table',[ClosedDate]=MAX('Table 2'[Date])))Measure 2 = COUNTROWS(FILTER('Table',[CreatedDate]=MAX('Table 2'[Date])))I filled in the dummy data you gave, so the result may be different. You can check more details from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
