Forum Discussion
Line Graph Displaying Created vs Resolved Tickets Overtime
Hi, I've tried numerous ways on getting a line graph with 2 lines showing the created vs resolved tickets however am running into issues. I am fine with the tickets marked as resolved displaying, however don't know how to show the variation of "created" tickets overtime. I have also tried adding the Status column to the values section filtering by status and this doesn't work either because of the open tag status.
I've tried creating a userrelationship, however am getting identical values using the following measures:
Do I need to use created time + resolved time tables instead of created time + a resolved measure?
Any help would be appreciated!
1 Reply
Caiz , Have you joined both resolve time and created time with date table and one of them is active and another one is inactive
One more thing you should check date to not have timestamp(this not for this issue, but you will not get correct numbers with join)
Refer my HR blog or video on same topic
