Table card percentages
Options
ggountanis
Member
in Beast Mode
I'm working on a table card and I can't get the percent of total. I've tried a lot of things and I can't get the percent of total to come out. I have 193 total. Does anyone have any ideas?
0
Answers
-
@ggountanis You'll need to use a FIXED() function to get the total of all the categories combined:
SUM(1)/SUM(SUM(1)FIXED()) -This assumes that your data is at the employee level
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
3 -
Agree with @RobSomers . Fixed functions are great for this use case. You can find more information on them here with several examples.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 571 Beast Mode
- 11 App Studio
- 27 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 351 Distribute
- 91 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 87 Community Announcements
- 4.8K Archive