pivot table column percentages
Is there anyway to display percentages in pivot tables, in terms of cell count vs total column count?
I have attached an example.
In each cell with 'XX.XX%' I want to display the percentage of the count for that cell divided by the grand total for that month.
E.G. the percentage cell for "2020-Apr, In SLA" should show 93.25% (using cell count 22715 divided by column count 24358).
Thanks
Best Answer
-
https://www.youtube.com/watch?v=ZPf41Fjn1H8
I did a tutorial video on this very topic!
Check it out.
You may need to contact your CSM to get 'window functions enabled in beast modes' before you can proceed.
here's another permutation of Window Functions in case you're interested. https://www.youtube.com/watch?v=cnc6gMKZ9R8
Hope this helps!
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"4
Answers
-
https://www.youtube.com/watch?v=ZPf41Fjn1H8
I did a tutorial video on this very topic!
Check it out.
You may need to contact your CSM to get 'window functions enabled in beast modes' before you can proceed.
here's another permutation of Window Functions in case you're interested. https://www.youtube.com/watch?v=cnc6gMKZ9R8
Hope this helps!
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"4
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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive