Forum Discussion
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
- lbendlinSuper User
The download link is not valid.