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 i...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
6 years ago

The dates have time, I created a new column without the time and joined with date dimension. Create some new column in date dimension.

 

https://www.dropbox.com/s/a4pnoz1fj721e6v/Incident_Mock.pbix?dl=0

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks amitchandak!

 

This is looking better, in the file you provided how could I add the Teams to the legend? I am assuming this would be the way to view the graph by Team. Also any idea how do go about creating the second bar chart I listed above? or if you have any recommendations that you would use to chart this data?

 

In terms of the columns you added, I had a few questions to help me understand. 

 

Why do we need to create the Month Year and the MonthYearSort columns in the DateTable? I thought by setting the formats of all the dates the same via clicking on the column and choosing the mm/dd/yy format for all it would ignore the hours.

 

You created a Open Not Closed measure with the following, I need some help understanding the FILTER piece: 

Open not closed = CALCULATE(COUNTX(FILTER('Mock Data','Mock Data'[Open DT]<=max(DateTable[Date]) && (ISBLANK('Mock Data'[Close DT]) || 'Mock Data'[Close DT]> max(DateTable[Date]))),'Mock Data'[Incident ID]),CROSSFILTER(DateTable[Date],'Mock Data'[Open DT],None)). 
 
If I read this correctly, the filtering section is filtering Open Dates within the DataTable(Date) range, also counting for any Blanks in the Close DT column, what I am confused is with the section in bold above, would this ever occur?
 
 
Thanks!