How do you create a waterfall chart based on counts of 2 date fields on the same row item?
My date set looks like this:
Unique ID | Created Date |Closed Date
Each row represents when a support ticket has been opened and closed. I would like to see by month, what is the net number of support tickets a technical team gets. For example, if for January, we received 10 total new tickets (i.e. created date) and we were able to close 6 of them (i.e. close date), on the water fall chart in January, it would show +4 . For Feb, we received 5 total tickets and we were able to close 6, then on the water fall chart in Feb, it would show -1
Is this possible to create in QuickSight?
Thanks in advance.