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.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.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.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 970 Connectors
- 259 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 502 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 379 Beast Mode
- 21 Variables
- 487 Automate
- 104 Apps
- 379 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 319 Distribute
- 67 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 64 Community Announcements
- 4.8K Archive