Using a Beast Mode Calculation in Summary Number
Hi,
I'm trying to create a beast mode that will allow me to use CASE WHEN COUNT as a summary number and I'm having some trouble. I've tried this with SUM and AVG in front. I've tried subtracting the Like count from the Not Like count. I'm not sure how to turn this into an aggregation so that I can use it in the summary. Thoughts?
(CASE WHEN `Primary DNS` NOT LIKE '208.67.222.222' THEN COUNT(`Serial Number`) END)
Best Answer
-
You can control the aggregation in the the beast mode function itself. I would write a new beast mode that would be
(CASE WHEN `Primary DNS` NOT LIKE '208.67.222.222' THEN 'Yes' END)
I would then put this beastmode in your summary number and choose the count function under the field and function option.
I would think that it would not count the null value. Let me know if this works.
0
Answers
-
You can control the aggregation in the the beast mode function itself. I would write a new beast mode that would be
(CASE WHEN `Primary DNS` NOT LIKE '208.67.222.222' THEN 'Yes' END)
I would then put this beastmode in your summary number and choose the count function under the field and function option.
I would think that it would not count the null value. Let me know if this works.
0 -
That did work when I put the COUNT around it. Thanks so much.
0 -
Glad I could help!
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