Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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!
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!