Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Time Line Graph Open vs Closed Tickets

I am trying to display a time line that will show the number of tickets closed vs the number of tickets opened by Team Assigned and Owner Assigned (these could be 2 different graphs, my main issues is showing the actual timeline of open vs closed tickets).

 

My Source Data Looks Like This:

If the Closed Date Column has an EMPTY cell, its because the incident hasnt been closed.

 

Following some previous suggestions, I have:

 

1. Created a DataTable using: DateTable = CALENDARAUTO(). My understanding is that this will be used in the X Axis of the line chart.

- I formatted the DataTable and the Open and Closed Date Columns as date  to mm/dd/yyyy

 

2. Created two relationships:

- One to Many Direct Relationship from DataTable[Date] to Mock Data[Open Date]

- One to Many Indirect Relationsip from DataTable[Date] to Mock Data[Closed Date]

 

3. Created 3 Measures:

- Closed = COUNTA(Mock Data[Closed Date])

- Open = COUNTA(Mock Data[OpenDate])

- ClosedByDate = CALCULATE([Closed], USERELATIONSHIP(DateTable[Date], Mock Data[Closed Date]))

 

4. Add the Line Chart - I've tried different combinations but just end up with a blank chart.

- Axis: Mock Data[Closed Date]))

- Values: ClosedByDate

 

Any help would be really useful.

 

Thanks!

8 Replies