6 Replies Latest reply on Jul 23, 2017 9:43 PM by T G

    Aggregation showing Opened and Closed Tickets Over Time

    B W
      Date
      Jan 1
      Jan 8Jan 22Jan 29Feb 5Feb 12

      Feb 19

      Opened##
      Closed##

       

      Hi,

       

      I have a dataset attached with three columns- transaction ID, opened date, and closed date. I need to show in a crosstab (see above) as well as either a line or bar chart how many tickets were opened or closed in a year. I've plotted it in a line chart but I'm not sure how to do this in a crosstab. "duplicate as crosstab" doesn't do what I need- it puts one date field in the columns and another in the rows. Is there a way to do this in tableau with the data as formatted? Customer is asking for it this way and we cannot add another data set into the workbook with aggregated data.

       

      Thanks for any help!