Can you create a Summary Number that shows a subtotal percentage?
Good afternoon,
Is there a way to create a Summary Number that shows what percentage a subtotal represents? For example, if I have a table that is showing 10 rows out of 1,500 rows, and those 10 rows equal 20% of my sales for the month, how can I create a Summary Number that shows 20%?
THanks!
Best Answer
-
@Joe_M , it sounds like you'll need a window'ed function to build out the metric you're looking for.
You may have to check with your CSM to get 'window functions enabled in beastmodes' before you can build it all out.
This tutorial can work as a foundation! Good luck!
https://www.youtube.com/watch?v=ZPf41Fjn1H8&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=20
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
@Joe_M , it sounds like you'll need a window'ed function to build out the metric you're looking for.
You may have to check with your CSM to get 'window functions enabled in beastmodes' before you can build it all out.
This tutorial can work as a foundation! Good luck!
https://www.youtube.com/watch?v=ZPf41Fjn1H8&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=20
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Thanks Jae; I did reach out to see what would be possible. Thanks for the quick reply.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 743 Beast Mode
- 58 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
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive