2 Replies Latest reply on Jul 6, 2016 1:54 AM by Anh Ho

# sum and display data as percentage compared to a fixed number

HI all,

I have an Excel file which data showing the time the carpark is occupied in three days. I want to show the occupancy rate (in percentage) for each car park for three days.

In other words, each car park has a fixed total time of  60 minutes per hour x 24 hours a day x 3 days = 4320 minutes. I was able to display total occupied minutes for each carpark as below:

However, I want to compare the occupied minutes for each car park against 4320 minutes and display in percentage, in bar chart. For example, occupancy rate for carpark no. 1 is 931/4320*100=21.55%, I want to be able to calculate that number and display in bar chart.

I attached tableau workbook and excel source below.

Thank you

• ###### 1. Re: sum and display data as percentage compared to a fixed number

Did you try simply dividing sum by your constant value of 4320 and then formatting the number as percentage?

• ###### 2. Re: sum and display data as percentage compared to a fixed number

I works. Thank you