Ignore filters + include ALL entires of a specific measure in a formula, but filter other measures
I am tracking performance of a manufacturing process, and the various reasons parts get rejected. I can easily chart (Parts Rejected)/(Parts Run) aggregated by day for a reject rate, but I would also like to be able to separate the reasons out as a series. The formula I am after is then:
(Parts Rejected by Filtered Reasons)/(ALL Parts Run regardless of "reason" filter)
Here is a fictional data table of a single day, with a breakdown of what I want v. what I am getting. It makes sense what Domo is doing - filtering the dataset down to each "reason" and charting the first formula from that subset - but I would like a way for it to behave differently. I am aware I could create a new flow and aggregate each reason as I want, but this removes some other flexibility and capabilities I would like.
Currently I cant display the reasons as a series, and have it as a filter. Even then however the user must select the reason(s) they want AS WELL AS the 'blank' checkbox to include all the parts that were not rejected. However still as I am typing this I am realizing that excludes all the parts run that were rejected for a different reason so actually I am misrepresenting the data with that...
I guess perhaps a better way to word all this is I want some calculations to ignore other types of filters. I am coming from PowerBI where I could indicate if a measure used in a formula was to ignore any filters, and I am missing that level of control...
- 10.7K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board