Charting

Ben_Gilbert
Ben_Gilbert Member
in Charting

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

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    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.

    image.png
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    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.

    image.png
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Ben_Gilbert
    Ben_Gilbert Member

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

Categories