Possible to use a value that ignores filters?
I'm looking for a way to use a value in a beast mode formula that ignores my current filters. I've been wrapping my head around this problem and can't think of another way to solve it. Here is an example with my issue:
Let's say my company has 5000 employees. There is a survey database with multiple rows of data for each employee. Some employees have completed multiple surveys, some no surveys, and some have completed 1 survey and didn't complete others. If I sort by unique employees, the table will look something like:
Unique Employees Not Completed Survey: 3000
Unique Employees Completed Survey: 4000
Total Unique Employees: 5000 (Using 'show total' Chart Properties option)
I can't display this data in a vacuum because it'll look like we have 7000 employees when we only have 5000. I also want to be able to show the % of employee who have completed any survey vs those who have completed none (4000 vs 1000 or 80% vs 20%).
What I think I want is to be able to do is pull a total unique employee count as a static variable while being able to bypass any filters (to always use 5000). Let's call it 'TotalEmployees.' This would allow me to create a percentage by placing my filters and allowing me to divide Count(Distinct)/TotalEmployees or Subtract: TotalEmployees-Count(Distinct) to show the number of employees who have not taken any survey.
Other solution options are welcome, but I've been working on this problem for a week and can't think of a way to get what I want and be able to display it in a chart form.
Best Answer
-
You could use FIXED BY function(s) that ignores filters:
See "Applying Filter Logic" section, use case #1.
If I solved your problem, please select "yes" above
1
Answers
-
You could use FIXED BY function(s) that ignores filters:
See "Applying Filter Logic" section, use case #1.
If I solved your problem, please select "yes" above
1
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 280 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 562 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 587 Beast Mode
- 13 App Studio
- 28 Variables
- 585 Automate
- 142 Apps
- 415 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 94 Manage
- 91 Governance & Security
- 9 Product Release Questions
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive