2 Replies Latest reply on Mar 19, 2018 7:41 AM by Matt Pallini

    Blending dates to track months between start and end dates

    Matt Pallini

      I am working on a project where I need to show all open tickets in each of the last 12 months.  However, my data set only includes a start and end date, not a record for each month an item is open.  For example, if a ticket is opened in January and closed in April, I need to show a record of it in January, February, March, and April.  I tried to blend in a table that just show the 1st of the month for the last 12 months, but I don't have a field in my data to blend it on.

       

      I have recreated what I am trying to do with the Superstore data set in Tableau 10.5.  Sheet 2 has where I have gotten stuck.  I tried creating a filter (Order Pending field in the workbook) by putting the generic date between my start and end dates, but there is an issue with the aggregation.  I really appreciate any ideas or suggestions that anyone has.

       

      Thanks