Variables
Variables
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 DateIS NOT NULL THEN 1 ELSE 0 END)- SUM(CASE WHEN
aIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
bIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
Total cIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN CONCAT(
d,' ',e) !='string' AND CONCAT(d,' ',e) !='string2' ANDfIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d= 'string3' ANDgIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d= 'string3' ANDgIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d= 'string3' ANDgIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d= 'twitch' ANDgIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
Total Production FollowersIS NOT NULL THEN 1 ELSE 0 END)
)
/
)
)
WHENCampaign Metrics= 'Engagement Rate' THEN(
(SUM(CASE WHENPost DateIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
aIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN CONCAT(
d,' ',e) !='string4' AND CONCAT( `d` ,' ',e) !='string5' ANDTotal cIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
Total Production FollowersIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d= 'string4' ANDiIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d= 'string4' ANDjIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d= 'string4' ANDkIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d= 'string4' ANDlIS 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 DateIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
aIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN CONCAT(
d,' ',e) !='string4' AND CONCAT( `d` ,' ',e) !='string5' ANDTotal cIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
Total Production FollowersIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
d= 'string4' ANDiIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
d= 'string4' ANDjIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
d= 'string4' ANDkIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
d= 'string4' ANDlIS 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 DateIS NOT NULL THEN 1 ELSE 0 END)- SUM(CASE WHEN
aIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN CONCAT(
d,' ',e) !='instagram photo' AND CONCAT(d,' ',e) !='twitch stream' ANDTotal cIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
d= 'string4' ANDiIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
production_type= 'string4' ANDjIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
production_type= 'string4' ANDkIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
production_type= 'string4' ANDlIS NOT NULL THEN 1 ELSE 0 END) - SUM(CASE WHEN
Total Production FollowersIS NOT NULL THEN 1 ELSE 0 END)
)
/
(SUM(CASE WHENPost DateIS NOT NULL THEN 1 ELSE 1 END)
)
)
END - SUM(CASE WHEN
aIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN CONCAT(
d,' ',e) !='instagram photo' AND CONCAT(d,' ',e) !='twitch stream' ANDTotal cIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
d= 'string4' ANDiIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
production_type= 'string4' ANDjIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
production_type= 'string4' ANDkIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
production_type= 'string4' ANDlIS NOT NULL THEN 1 ELSE 1 END) - SUM(CASE WHEN
Total Production FollowersIS 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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive