Forum Discussion
Capture Outstanding IT Ticket Count over Time Time
I have what I hope is an interesting problem for someone... I'm tracking IT performance and am trying to capture the number of tickets open greater than 30 days over time. I'm struggling with the...
Sure! While I can't share the pbix file, here is the (simplified) underlying data.
Also, here are what totals should be (*Nov as of 11/27):
| Month | Count |
| Nov-19* | 297 |
| Oct-19 | 236 |
| Sep-19 | 221 |
| Aug-19 | 179 |
| Jul-19 | 214 |
| Jun-19 | 308 |
| May-19 | 275 |
| Apr-19 | 262 |
| Mar-19 | 285 |
| Feb-19 | 268 |
| Jan-19 | 254 |
Hi,
How did you arrive at the figure of 214 for July 2019? With respect to the MS Excel file that you have shared, please ber very clear with what filters/conditions have you applied to arrive at that figure.