Variables as Checkbox - Unimplemented Error
Hi All,
Love these forums! Anyways.
I created a beast mode calculation that takes into consideration my Campaign Metrics
variable values.
CASE WHEN Campaign Metrics
= 'A' THEN (…)
WHEN Campaign Metrics
= B THEN (…)
ETC…
If I try to change the variable's control type [from a dropdown] into a checkbox selector [which allows multiple selections], DOMO returns the following error —>
I tried changing the beast mode to account for multiple selections, but still received the same error. For ex —>
CASE WHEN Campaign Metrics
= 'A' and Campaign Metrics
= 'B' THEN(…
I cannot even find an example online of people using checkboxes for variables. Any help is very much appreciated!
Answers
-
@emmanuel_fabre Can you please share your beast mode code and some more information about how you are using it in your card?
0 -
Beast Mode —>
`CASE WHENCampaign Metrics
= 'Clicks - CTR' THEN((SUM(CASE WHEN
Post Date
IS NOT NULL THEN 1 ELSE 0 END)- SUM(CASE WHEN
a
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
b
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
Total c
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN CONCAT(
d
,' ',e
) !='string' AND CONCAT(d
,' ',e
) !='string2' ANDf
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d
= 'string3' ANDg
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d
= 'string3' ANDg
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d
= 'string3' ANDg
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d
= 'twitch' ANDg
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
Total Production Followers
IS NOT NULL THEN 1 ELSE 0 END)
)
/
)
)
WHENCampaign Metrics
= 'Engagement Rate' THEN(
(SUM(CASE WHENPost Date
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
a
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN CONCAT(
d
,' ',e
) !='string4' AND CONCAT( `d` ,' ',e
) !='string5' ANDTotal c
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
Total Production Followers
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d
= 'string4' ANDi
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d
= 'string4' ANDj
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d
= 'string4' ANDk
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d
= 'string4' ANDl
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN ifnull(((
Total m
)+(k
)+(l
))/(Total c
),0) > 0 THEN 1 ELSE 0 END)
)
/
(
)
) - SUM(CASE WHEN
Post Date
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
a
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN CONCAT(
d
,' ',e
) !='string4' AND CONCAT( `d` ,' ',e
) !='string5' ANDTotal c
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
Total Production Followers
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
d
= 'string4' ANDi
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
d
= 'string4' ANDj
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
d
= 'string4' ANDk
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
d
= 'string4' ANDl
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN ifnull(((
Total m
)+(k
)+(l
))/(Total c
),0) > 0 THEN 1 ELSE 1 END)
WHEN
Campaign Metrics
= 'Views' THEN((SUM(CASE WHEN
Post Date
IS NOT NULL THEN 1 ELSE 0 END)- SUM(CASE WHEN
a
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN CONCAT(
d
,' ',e
) !='instagram photo' AND CONCAT(d
,' ',e
) !='twitch stream' ANDTotal c
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d
= 'string4' ANDi
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
production_type
= 'string4' ANDj
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
production_type
= 'string4' ANDk
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
production_type
= 'string4' ANDl
IS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
Total Production Followers
IS NOT NULL THEN 1 ELSE 0 END)
)
/
(SUM(CASE WHENPost Date
IS NOT NULL THEN 1 ELSE 1 END)
)
)
END - SUM(CASE WHEN
a
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN CONCAT(
d
,' ',e
) !='instagram photo' AND CONCAT(d
,' ',e
) !='twitch stream' ANDTotal c
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
d
= 'string4' ANDi
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
production_type
= 'string4' ANDj
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
production_type
= 'string4' ANDk
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
production_type
= 'string4' ANDl
IS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
Total Production Followers
IS NOT NULL THEN 1 ELSE 1 END)
0 - SUM(CASE WHEN
-
I am using it to display one percentage value in a 'Filled Guage' chart. It works fine as a dropdown, but not as a checkbox
@MichelleH Thanks, by the way!
0 -
@emmanuel_fabre How should the percentage value behave when multiple values are selected? For example if "Clicks - CTR" = 95% and "Engagement Rate" = 50%, what should the single percentage be and what does that mean?
0 -
@MichelleH
In a recent iteration of my beast mode, I included a CASE WHENCampaign Metrics
= "Clicks - CTR" ANDCampaign Metrics
= "Engagement Rate" THEN(…
I believe I created a case statement for each possible 'combo', but I am doubting myself as I type this. I am going to try to recreate every combo in a new beast calc, and see where that goes0 -
@MichelleH.
I just updated the beast mode to include all [7] possible combos—
Eng Rate
CTR
Views
Eng Rate + CTR
Eng Rate + Views
Eng Rate + CTR + Views
Views + CTR
It still errors out only when selecting checkbox0 -
@emmanuel_fabre Can you please explain the business logic of the calculation? I see some opportunity to simplify your original beast mode in a way that could resolve the errors, but need more details to be able to provide input
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 60 App Studio
- 41 Variables
- 687 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive