Waterfall chart based on counts of 2 date fields on the same row

Question & Answer
1

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.

2

I don’t think it’s possible with the current way you have it set up.

However, what might work is transforming your data set to be in the format of

Date | Unique ID | Created_or_Closed

Where the date would be either a created date or closed date. The ID would be the ID. And then you would list the type if it’s created or closed date.

Then you should be able to take a count of id’s grouped by month and the breakdown would be created or closed type.