Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Stacked chart with positive (additions) and negative (removals), plus running total

I'm running into a problem where I'm not sure how to get the removal data information to display correctly. For example, for ticket m1, the creation date falls properly in November, but on the chart the removal date also shows up in November vs December (I do have creationDate as the relation to the calendar so that's why it is occuring, but I don't know how to resolve).

 

May I please get your help with

1) I have creations charted in the month they were created, but how do I show removals in the month they were removed 

2) What would be the best way to create a running total to show how many tickets are currently open for a particuar month? Is the new window DAX function a good candidate for this?

Thank you

https://www.dropbox.com/s/ymmn9ma8z6haf1j/stacked%20chart%20with%20postive%20and%20negative%20and%20running%20total.pbix?dl=0 

 

This is what I'm trying to accomlish:

Example of what I'm trying to accomplish

 

But the problem is that removed tickets show up in the same month as when the IT ticket was created (and the rolling open Tickets is not properly working)

snippet of attached pbix

Data for cut & pasting into PBI:

entryticket#creationDateRemovalDate
1m15-Nov-221-Dec-22
2m228-Nov-222-Dec-22
3m32-Dec-225-Dec-22
4m45-Dec-2220-Dec-22
5m520-Dec-2224-Dec-22
6m625-Dec-224-Jan-23
7m711-Jan-2314-Jan-23
8m814-Jan-23 
9m918-Jan-23 
10m1020-Jan-23 

 

visual table of the expected output:

For charting  
MonthAdditionsRemovalsRolling Open IT Tickets
2022-Nov202
2022-Dec4-51
2023-Jan4-23