1 Reply Latest reply: Mar 19, 2012 2:04 PM by Brandon Apperson RSS

    modifying labels in a chart

      I am using a pie chart, in which i get data as 1 and 0. while displaying labels i want 1 to displayed as 'a' and 0 to be displayed as 'b'. Where should i write an expression for this?

        • modifying labels in a chart

          I'm not sure where the 1's and 0's are coming from, but ultimately the expression would be the same.  If you only have 1's and 0's you could add a calculated dimension (right click->properties->dimensions tab) and write in:

           

          =if([Field] = 1, 'a','b')

          where field is the data comprised of 1's and 0's.

           

          I think that should get you your desired results.

           

          Hope this helps!