4 Replies Latest reply on Aug 16, 2018 2:47 AM by Naveen B

    Pie chart with discreate measure

    Prajna Das

      Hi ,

       

      I have a made a category using a calculation .Now need to show how many city fall under these category by a pie chart.

       

      if [CAL_Coverage %] >= 1.2 THEN "Over(>120% )"

      ELSEIF [CAL_Coverage %] >= .8 and [CAL_Coverage %] < 1.2 THEN "Ideal  (80%-120% )"

      ELSEIF [CAL_Coverage %] > 0 and [CAL_Coverage %] < .8 then "Under (<=80% )"

      elseif sum(population) =0  then "Not "

      else "Over  (>120% )"

      end

       

      cal_coverage%= sum(population)/sum( recomeded population)

       

      City is a dimension.

       

       

      Over
      (>120%)
      Ideal (80%-120%)
      Under (<80%)
      Not