Line Graph Displaying Created vs Resolved Tickets Overtime

[Caiz]

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!

[amitchandak]

@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-tr...

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