1 Reply Latest reply on Mar 2, 2017 4:20 PM by Alexander Mou

    Pie chart with 2 measures

    Radi Saran

      if

         attr( year([Date]) ) = 2017

       

      then "Filter3"

       

      ELSEIF (

      attr(year([Date]) ) < 2017

      OR  ISNULL(ATTR([Date]))

      )

       

      AND

       

      (

       

      ATTR([Status]) = "INACTIVE"

      or

       

                  NOT (

      ATTR([Industry]) != "GROCERY"

                  AND attr([Industry]) != "MINING’" 

                  AND ATTR([Industry]) !="OIL"

                  AND  attr([Industry])!= "POWER"

                  AND  attr([Industry])!= "ELECTRICAL"

      )           

       

      )

      THEN "Filter1"

       

      ELSEIF

      (

      attr(year([Date]) ) < 2017

      OR  ISNULL(ATTR([Date]))

      )

      AND ATTR([Status]) != "INACTIVE"

       

      AND

       

      (

      ATTR([Industry]) != "CELL_PHONES"

      AND attr([Industry]) != "MINING" 

      AND ATTR([Industry]) != "CAR_AUDIO"

      AND  attr([Industry])!= "POWER"

      AND  attr([Industry])!= "ELECTRICAL"

      )           

       

      THEN "Filter2"

      END

       

      I have the above as formula in the calculated formula. The result is created as a measure. Now I want to use the calculated field and countd(another measure) as a piechart. I cannot do it.. Any thoughts?