Forum Discussion

ShaneP09's avatar
ShaneP09
New Member
3 years ago

Open vs Resolved Tickets - Column chart

Hi, and thanks in advance for your help!

 

I've ran through a few posts on the PBI board but still struggling to get my report/data to display correctly. The goal is to create a column chart with tickets opened (Created) vs tickets resolved, over time, from the 'Rapid' data set, grouped by 'Month Year'.  

 

I've created a date table, and linked the relationships via the Created (active) and Resolved (non-active) columns in the 'Rapid' table. I've also created a few measures to calculate the Open and Resolved totals.

 

Test Desktop report/data can be found here: One Drive pbix link - test data

 

You can see in the below table it is only linking one 'Resolved' ticket to a date. 

 

Any suggestions/tips would be awesome. Thanks again

1 Reply