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.Airtwo3jrdn
I work for Domo
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"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.Airtwo3jrdn
I work for Domo
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"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.Airtwo3jrdn
I work for Domo
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 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