Dates Being Filtered with Fixed
I'm using the following FIXED expression in one of my Beast Mode functions. The function is showing the right numbers, but when I try filtering by errorCode, it only shows attempt numbers for days when the errors occurred. I want to see the number of attempts for each day, regardless of whether an error was selected or not.
Attempts
SUM(
SUM(
'attempts'
) FIXED (BY date
FILTER DENY errorCode
)
)
This is the standard view when no errors are selected (this shows the daily attempts, errors, and error ratio - the errors are all errorCodes combined). Here it shows numbers for all days, even when there are 0 attempts or errors (as it should):
If I filter by one of the errors, the error numbers are correct, but the visual only shows attempt numbers for days when the errors occurred:
In the end, when filtering by errorCode, I want to show the same attempt numbers for all days from visual 1, with error numbers from visual 2. Is there any way to do this with the FIXED function?
Thank you!
Answers
-
Can you try adding your Error Ratio calculation into the filter deny clause as well?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
@ST_-Superman-_ Thanks for the quick reply. I get an error when trying to put the error ratio calculation in the deny clause.
Here are the actual formulas - might provide a hint as to why.
Attempts:
SUM(
SUM(
CASE
WHEN … IN(X, Y, Z)
AND …
AND …
THEN 1
ELSE 0
END
) FIXED (BYdate
FILTER DENYerrorCode
)
)Failures:
SUM(
CASE
WHEN … IN(X, Y, Z)
AND …
THEN 1
ELSE 0
END
)Error Ratio:
I get an error when I try putting in the Error Ratio calculation into attempts DENY clause, like so:
SUM(
CASE
WHEN … IN(X, Y, Z)
AND …
THEN 1
ELSE 0
END
)
/
SUM(
SUM(
CASE
WHEN … IN(X, Y, Z)
AND …
AND …
THEN 1
ELSE 0
END
) FIXED (BYdate
FILTER DENYerrorCode
)
)SUM(
SUM(
CASE
WHEN … IN(X, Y, Z)
AND …
AND …
THEN 1
ELSE 0
END
) FIXED (BYdate
FILTER DENYerrorCode
,
(Above Error Ratio Calculation)
)
)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
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 655 Automate
- 170 Apps
- 438 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 383 Distribute
- 110 Domo Everywhere
- 267 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive