How to calculate Percentage in each Series - Bar graph
I have created a card that displays total population of universities with respect to its ACT value. I want to create a card like below,
I have created a beast mode calculation to determine the percentage in each of its series. My beast mode calculation,
Case when `Public/Private`='Public' then sum(`Undergraduate Population`) when `Public/Private`='Private' then sum(`Undergraduate Population`) else 0 end / sum(`Undergraduate Population`)
This gave me a chart something like below,
I could not get the total by getting sum(`Undergraduate Population`) - it divides based on the University type - Public/Private
It would be fine helpful if someone could help me get the Total value - sum of population from both private and public. Thanks in advance !
Best Answer
-
Hi @Dharshini, in 'Chart Properties' -> 'Data Label Settings' -> 'Text' -> '%_PERCENT_OF_CATEGORY', you can show the data in each stacked bar as a % against the total along each for your ACT Lower values, showing the bars data exactly as your first image.
Hope that helps.
10
Answers
-
Hi @Dharshini, in 'Chart Properties' -> 'Data Label Settings' -> 'Text' -> '%_PERCENT_OF_CATEGORY', you can show the data in each stacked bar as a % against the total along each for your ACT Lower values, showing the bars data exactly as your first image.
Hope that helps.
10 -
Hi Amehdad, was able to get the result with '%_PERCENT_OF_CATEGORY' exactly the way I wanted.
Found it helpful. Thanks !
2 -
Hi @Dharshini another alternative is window functions which allow you to aggregate across a partition / subset of your entire dataset. You need to have your CSM turn it on in your instance to utilize them in beast modes.
SUM(undergraduate_population) / sum(sum(undergraduate_population)) over (partition by act_score)
I would go with @amehdad21 ‘s solution as it’s the simpler option in your case but wanted to make you aware of another solution which might be beneficial in the future for you
Sorry for the bad formatting I’m on mobile and vacation :)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive