Filtering on Calculated Values
I have a Beast Mode that is calculating the difference between 2 columns. I need a filter that will give me all of the values that are $10k and above and all values that are -$10k and below. I assume I need to create a 'When' Beast Mode that includes both of the filters, but I am getting a Syntax error. I am thinking maybe it is because the column I am using is the calculated field. Any suggestions on accomplishing this? Thanks!
Best Answer
-
Hmm I am not getting the same error, see below:
Could you screenshot your beastmode so we can take a look?
If I solved your problem, please select "yes" above
1
Answers
-
This is possible, but to help we need a bit more information. Could you share the beastmode field and the other field you are using?
It will end up looking something like this:
CASE WHEN `Field1` - `CalculatedField` >= 10000 THEN 'In'
WHEN `Field1` - `CalculatedField` <= -10000 THEN 'In'
ELSE 'Out' ENDThen you will use the above beastmode as a filter on the card with the condition that 'In' is in.
The `CalculatedField` above could either be:
1. A nested beastmode, which is a new feature just announced that requires requesting access to via your CSM.
2. Your calculated field re-typed in this filter beastmode.If I solved your problem, please select "yes" above
0 -
My calculated column Beast Mode is called FluctCurrVsYest with the calculation of SUM(
Current Balance
-Yesterday Balance
). When I choose it in my new Beast Mode it inserts the calculation, not the name. The error I receive is: 'Calculation Error : This calculation contained a syntax error.' Here is the Beast Mode I receive the error on:CASE
WHENSUM(
Current Balance-
Yesterday Balance)
>=1000
THEN '1'
WHENSUM(
Current Balance-
Yesterday Balance)
<=-10000
THEN '1'
ELSE '2'
ENDThanks!
0 -
Hmm I am not getting the same error, see below:
Could you screenshot your beastmode so we can take a look?
If I solved your problem, please select "yes" above
1 -
Looks like I had too many ` symbols. I was able to get it to work by using yours as a guide. Thank you VERY VERY much!
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive