Hello Robert - First of all I have almost no idea related to the process of Ticket Generation system and how management looks at the data. Apology for that. I have made an assumption for ease of calculation that if Close Date (Ticket is open) is Null then that is considered as Today.
Now the data looks like following :
Now I have created a Calculated field called "Logical Close Date"
and then Calculate Open Days
Find out the the Number of SR raised per Month called "Count of SR"
Finally the Viz. looks like this:
Will this help ?
Thanks for the reply. It's close but not quite. I modified your excel file to show you the desired outcome. See below and the attachment.
As you see, in Excel, this is relatively straightforward, but I can't figure it out in Tableau.
I appreciate the help!
Ticket Data_updated.xlsx 13.9 KB
Tableau generally doesn't do well reporting with data that doesn't exist. In your case the month end dates do not exists in your dataset. Creating a table of month end dates then full joining on your dataset would make it bit easier to generate your desired output.
I've attached a twbx demonstrating this process to achieve your desired outcome. Let me know if you have any questions.
Avg Days Open.twbx 13.4 KB