3 Replies Latest reply on Apr 2, 2017 11:20 PM by shekhar kumar

    Hi Team, Currently I am migrating Domo to Tableau , I am facing with Calulated field mismatch. can any one help me in this calculation how we can right in tableau ? this calculation was from DOMO i have to convert in to tableau how i can write in tableau

    shekhar kumar

      given below are the domo calculted field ,Query. Its

       

      1 .YTD-

      SUM( CASE WHEN `Period` >= STR_TO_DATE(concat(year(`MaxClosedRptPeriod`),'-01-31'),'%Y-%m-%d') AND `Period` <= STR_to_date(Concat(year(`MaxClosedRptPeriod`),'-12-31'),'%Y-%m-%d') THEN `Amount` ELSE 0 END)

       

      2.PYTD-

       

      SUM (CASE WHEN `Period` >= STR_TO_DATE(Concat(Year(`MaxClosedRptPeriod`)-1,'-01-31'),'%Y-%m-%d')

           AND `Period` <= DATE_SUB(`MaxClosedRptPeriod`, interval 1 YEAR)

           THEN `Amount` ELSE 0 END)

       

      3.Growth-

       

      IFNULL((SUM( CASE WHEN `Period` >= STR_TO_DATE(concat(year(`MaxClosedRptPeriod`),'-01-31'),'%Y-%m-%d') AND `Period` <= STR_to_date(Concat(year(`MaxClosedRptPeriod`),'-12-31'),'%Y-%m-%d') THEN `Amount` ELSE 0 END)

      /

      SUM (CASE WHEN `Period` >= STR_TO_DATE(Concat(Year(`MaxClosedRptPeriod`)-1,'-01-31'),'%Y-%m-%d')

           AND `Period` <= DATE_SUB(`MaxClosedRptPeriod`, interval 1 YEAR) THEN `Amount` ELSE 0 END))

      -

      1,0)