13 Replies Latest reply on Jul 26, 2016 8:07 AM by Steve Martin

    How to combine 2 different charts?

    vijay.kumar.10

      Please review the sample data in the attached file.

       

      I have Ticket numbers with Created Date and Resolved Date.

       

      I have created 2 different charts one for Created count for the particular month and the other for Resolved count on that particular month.

       

      Please see the screenshot from the sample graph I have created (Sample Chart 1).  Now I would like to combine this to one single graph as shown in sample screenshot  2. This is possible in Excel as we can enter manually to fill in data as below.

       

      Jan Created =1000 Closed =1500

      etc.,

       

      We can do a graphing on this but I am using tableau connected to SQL DB. 1st Graph = I have dragged Created On date --> Converted display to Month --> Dragged the number of records.

      Similarly 2nd Graph = I have dragged Resolved On date --> Converted display to Month --> Dragged the number of records.

       

      But I am not able to combine this to one graph since we are deriving Month field from 2 different column Created On and Resolved On