8 Replies Latest reply on Jul 17, 2018 7:40 AM by Aaron Duncan

    2 date fields - connected

    Aaron Duncan

      Hey Everyone,

       

      I have another question here, that i came across while trying two show a few different measures on the same trend graph. . As it is company data, workbook cannot be shared, however i think this is simple to explain.

       

      I have 2 tables, that i have joined from the data source. Each of which has a measure (or 2) that i need to show on a trend graph. Table 1 uses ISSUE_DATE as the date field and contains 2 measures that i need to show. Table 2 uses REDEMPTION_CREATED as the date field and contains 1 measure that i need to show on the same graph. .

       

      Is there a way that i can somehow link these two date fields and show all 3 measures (2 using ISSUE_DATE, 1 using REDEMPTION_CREATED) on the same trend graph? And then use 1 filter to change the scope of the trend graph?

       

      Please let me know if i need further explanation.