Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart where I am showing the percentage of the total: Count(Q2701)/Count(TOTAL Q2701)
The issue I am having is the Variable has numbers in the column but I would like it to display company names instead of the numbers.
So on the x axis instead of showing 1, 2, 3, 4. I would like 1 = Auto Company, 2 = Insurance Company etc etc...
What is the best way to do this?
create calculated dimension
IF(Variable=1,'Auto Company',IF(variable=2,'Insurance Company'))
try
create calculated dimension
IF(Variable=1,'Auto Company',IF(variable=2,'Insurance Company'))
try