FIXED Function As Background Filter
I have a headcount dashboard where I would like the cards to render 0 values in case of any filter combination resulting in the headcount <3. I created a beast mode calculation using fixed function to use it as a background filter in the cards. however when I am adding it to the cards and try to save it, it throws an error stating 'There was a problem saving your card. If the problem persists, contact Domo support team.'
Here is the beastmode I have -
SUM(COUNT(DISTINCT `EMPLOYEE_ID`) FIXED())
Best Answers
-
@Sumant_Kumar707 According to this KB article, FIXED functions are not supported as filters. I'd suggest adding this as an enhancement request in the Ideas Exchange.
1 -
Depending on the setup of the card/data, I think you should be able to change the Beastmode to just COUNT(DISTINCT
EMPLOYEE_ID
), add it as a Tooltip so that it's at the right level of aggregation and then use it as a filter.Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
1
Answers
-
@Sumant_Kumar707 According to this KB article, FIXED functions are not supported as filters. I'd suggest adding this as an enhancement request in the Ideas Exchange.
1 -
Depending on the setup of the card/data, I think you should be able to change the Beastmode to just COUNT(DISTINCT
EMPLOYEE_ID
), add it as a Tooltip so that it's at the right level of aggregation and then use it as a filter.Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
1 -
@MichelleH thanks for the KB article, it makes sense.
@DavidChurchman I will try that and see if it works.
0 -
Agreed with the others, I don't think you need the FIXED portion, as just a count(distinct) should filter it out. I had a client who did something similar and it worked great.
0
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
- 601 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 691 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
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 112 Manage
- 109 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive