Filter logic
How do you filter out for a a sum a vlaues that falls below a certain threshhold? For exmaple, I have a cost per metric broken out by a number a creatives, but I only want to see the creatives who have more than 5 starts over the last 3 months.
I have tried using my metric as the filter, I have tried writing a a case statement and using that as the filter and each time the result is the same. It leaves me with an inccorect value for my output metrics. What am i doing wrong here?
Comments
-
Hello
You will want to add the sum of the metric to your card. You can then add that metric to the filter section of the card editor and select your criteria to be less than or greater than your specified value.0 -
I thought you couldnt add beast modes as a filter? When I do, I get an error that data wont load....
1 -
Hello
You can add beastmodes to a filter. Try adding the beastmode to the X axis of the card to ensure data appears in your card. As long as data appears you can also add this to your filter.0 -
That doesnt seem to be the case.
Here is the beast mode working as a metric.
And here it is throwing an error as a filter:
1 -
Hello
Thank you for the screenshot. Beast modes can be added to a filter as long as they do not contain an aggregation. We have submitted this as an enhancement request. You can also submit this idea to the dojo here:
https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas
Another option is to build this aggregated column into a dataflow and then applying your newly created column to the filter.0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive