1 Reply Latest reply on Aug 16, 2018 4:00 PM by swaroop.gantela

    Get Open Ticket Ages by Month for Past Months

    David Matthews

      Looking for a hand by some Tableau Pros here. I have a dashboard that is showing Tickets that were created. I did a union to add an Opened and Closed event because the original records just had Opened and Closed dates on the same record. There are also some age columns. I am able to get the count of Open records for each month including the past however I have another requirement to show the age of the tickets each month for open tickets. I guess the trick is that they don't have to be open now, but they were at one point in past months. Hopefully someone has done this before and can lend a hand.