Line Graph Displaying Created vs Resolved Tickets Overtime

Caiz — Fri, 22 Jan 2021 03:47:29 GMT

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:

OPEN = COUNTA('October Tickets'[Created time])

CLOSED = COUNTA('October Tickets'[Resolved time])

RESOLVEDBYDATE = CALCULATE([CLOSED], USERELATIONSHIP ('Calendar'[Date], 'October Tickets'[Resolved time]))

RESOLVEDBYDATE gets the error "USERELATIONSHIP function can only use the two columns references participating in relationship"

Do I need to use created time + resolved time tables instead of created time + a resolved measure?

Any help would be appreciated!

Re: Line Graph Displaying Created vs Resolved Tickets Overtime

amitchandak — Fri, 22 Jan 2021 04:22:39 GMT

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

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

https://www.youtube.com/watch?v=e6Y-l_JtCq4

topic Re: Line Graph Displaying Created vs Resolved Tickets Overtime in DAX Commands and Tips

Line Graph Displaying Created vs Resolved Tickets Overtime

Re: Line Graph Displaying Created vs Resolved Tickets Overtime