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 -
Is it possible to get the x-axis of bar charts to ignore filters too?
I have 15 business units and when I filter data, some of those business units are filtered out but I still want them to show on the x-axis of the bar chart. Thanks
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive