% of total in dynamic Textbox
Trying to get a dynamic textbox to display the following:
"Sale Type 1:"
%_LAST_VALUE
%_OF_TOTAL
"Sale Type 2:"
%_OF_LAST_VALUE
%_OF_TOTAL
Looking at a few other questions asked on this forum, % of Total does not seem possible for dynamic textboxes. I have tried using Flex tables with the horizontal bar chart, but % of total only does it for each sale type, not as a % of total sales.
Is there a way to do % of total sales either in a dynamic textbox, flex table, or even a pivot table? I am trying to put this in a fairly small box on a story dashboard, so a large nested bar chart will not work.
Thanks,
Reed
Best Answer
-
Percent of total typically requires using window functions in beast modes, which is not enabled by default. If it isn't enabled, ask your CSM to enable window functions in beast modes. You can then use the following beast mode to calculate the percent of total:
sum(amount) / sum(sum(amount)) over ()
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Percent of total typically requires using window functions in beast modes, which is not enabled by default. If it isn't enabled, ask your CSM to enable window functions in beast modes. You can then use the following beast mode to calculate the percent of total:
sum(amount) / sum(sum(amount)) over ()
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 780 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 413 Distribute
- 121 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive