9 Replies Latest reply on Sep 21, 2016 9:14 AM by Matt Hong

# formatting metrics differently in a single bar chart

I have some % data and some ordinal data to display on a single horizontal bar chart. I can't seem to make the occupancy data as a percent and keep the other columns as numbers (or vice versa). How do I control the each of the metrics individually?

Thanks,

Bruce

• ###### 1. Re: formatting metrics differently in a single bar chart

Create two calculated fields, with one like this:

if [Metric] == 'Occupancy' then SUM([Result value]) end

and the other like this:

if [Metric] == '# of spaces...' then SUM([Result value]) end

Then just tweak their default properties individually.

Edit: Put both calculations on columns!

• ###### 2. Re: formatting metrics differently in a single bar chart

Thanks. Pretty easy solution!

• ###### 3. Re: formatting metrics differently in a single bar chart

It seems the function is rounding all the results to the nearest 1. So an occupancy of  50% is showing as 1. Occupancies less than .5  (50%) are being rounded to no value. I tried the round function to no avail.

• ###### 4. Re: formatting metrics differently in a single bar chart

Does this not work?

Right click on calculation -> Default properties -> Number format -> Number (Custom), tweak decimal places -> OK

• ###### 5. Re: formatting metrics differently in a single bar chart

No.

I had to tweak your formula because it was giving an error:

so I removed the sum function and it allowed me to continue. But now the rounding problem...

• ###### 6. Re: formatting metrics differently in a single bar chart

Is posting the workbook not an option?

• ###### 7. Re: formatting metrics differently in a single bar chart

I'll clean it up for sharing.

• ###### 8. Re: formatting metrics differently in a single bar chart

Hmm.

I did a paste values into a new workbook so I could clean  the data of identifiers and now it is working as you suggested.  This method is going to make my life a lot easier.

Thanks,

Bruce

• ###### 9. Re: formatting metrics differently in a single bar chart

Awesome!