Thickness of the bar

Berfin · March 25, 2021, 9:33am

I am working on an range chart to visualize occupancies in hours.

So i like to present the hours in % with the thickness of the bar.

Is there a way i can create/implement this?

Thanks in advance,
Berfin

christianp · March 25, 2021, 5:59pm

You can use the PERCENTTOTAL formula to do this.

https://www.dundas.com/support/learning/documentation/analyze-data/formulas/standard/percent-of-total

You would essentially create a measure using that formula, then use that measure as a data point label via the visualization on the data analysis panel.

Berfin · March 26, 2021, 10:09am

Hi Christian,
I applied it to my chart and now i can see the hours in percent.
My question now is, if there is a possibility to change the height of the bars due to the percentage value?

Thank you for your help.

christianp · March 26, 2021, 3:16pm

The height of the bar is currently corresponding to the hours. So if you’d like to display it in terms of percentage with uniform bar heights, I’d imagine you are better off re-visualizing this is a 100% stacked bar chart - this way, each bar is uniformly heightened and the percentages are key.