3 Replies Latest reply on Oct 26, 2016 8:29 AM by siraj.lakhani

    MTD, QTD, YTD in table using multiple metrics

    Melissa John

      I would like to create a table in Tableau which has MTD, QTD and YTD in the columns section of the table. In the rows, it would have different metrics such as Marketing, Profit, and Sales. I have attached a sample of the data and table I would like to create. I have tried doing it with this calculated field:

       

      count(if [DNA_Test_Results_Ready_Day_ID]>= DATETRUNC('year',today()) and [DNA_Test_Results_Ready_Day_ID] < today() THEN [Order_Number] END)

       

      However, that method only seems to work when I am using one metric, not multiple ones.