Charting

Ben_Gilbert

I am new to Domo and busy learning Analyzer.

example.xlsx

I'd like to know how to convert a bar chart (with two variables) into a line chart with percentages, so if you have a column with 75 Male General Managers and 50 Female General Managers, another column with 100 Male Executives and 50 Female Executives, and a final column with 65 Male Key Management Personnel and 35 Female Key Management Personnel.

Can DOMO do this conversion automatically or do you need to use beast mode (?) to calculate the percentages within each column?

I have attached a simple example, using excel to highlight what I am trying to do.

Any help greatly appreciated.

Thanks

Ben

MarkSnodgrass

Hi @BigWave ,

Saw your comment on my YouTube video. Glad you are finding them helpful. You can do what you want by creating two beast modes. One for the Male % and one for the Female %. They would look like this:

Male %

SUM(Male) / (SUM(Male) + SUM(Female))

Female %

SUM(Female) / (SUM(Male) + SUM(Female))

You would then drag them into your chart like in my screenshot below and format them to percentage. You can also change the data label so that your legend gives a proper display name.

Hope this helps.

MarkSnodgrass

Hi @BigWave ,

Saw your comment on my YouTube video. Glad you are finding them helpful. You can do what you want by creating two beast modes. One for the Male % and one for the Female %. They would look like this:

Male %

SUM(Male) / (SUM(Male) + SUM(Female))

Female %

SUM(Female) / (SUM(Male) + SUM(Female))

You would then drag them into your chart like in my screenshot below and format them to percentage. You can also change the data label so that your legend gives a proper display name.

Hope this helps.

Ben_Gilbert

thanks Mark - really appreciated and will check out the resource you listed.