Solved: Graph of Number and Percentage

Anonymous · ‎12-09-2022

Hi,

I have the table as below :

Capacity(TB)	%Subscribed	Used(%)	Baie
1980	18	64	0480
1980	188	61	0481
1980	193	65	0482
1980	19	63	0483
924	98	27	1015
924	91	26	1017

The % subcribed and %used is the % of Capacity.

I would like to create a graph as below but the %subcribed and used % must take into account the Capacity.

It means that when the %subcribed 188 % , it must be almost 2 times of Capacity.

Thank you in advance for help.

Tg

TomasAndersson · ‎12-09-2022

You need to compare the same thing, i.e. either use a percentage of both (with capacity being 100 %) or showing both in TB as a unit. This can be done either with calculated column or a measure.

An example of a calculated column that calculates how much capacity is subscribed to would be.

Subscribed_to_TB =
Table[%Capacity]*Table[%Subscribed]/100

Use this instead of %subscribed in the visual and the bars will scale.

If you want to show the percentage, you could either have a separate visual, or maybe use a seconday y-axis and show the %subscribed there.

Hope this helps!

View solution in original post

TomasAndersson · ‎12-09-2022

You need to compare the same thing, i.e. either use a percentage of both (with capacity being 100 %) or showing both in TB as a unit. This can be done either with calculated column or a measure.

An example of a calculated column that calculates how much capacity is subscribed to would be.

Subscribed_to_TB =
Table[%Capacity]*Table[%Subscribed]/100

Use this instead of %subscribed in the visual and the bars will scale.

If you want to show the percentage, you could either have a separate visual, or maybe use a seconday y-axis and show the %subscribed there.

Hope this helps!