-
percent change is showing a large #
I created this beast mode which has the logic (current value- previous value)/(previous value). however when I show it in the summary and change the format to percentage it gives me a large percentage number. I'm trying to calculate the difference between 2.88(prev) and 2.2(current) (avg(CASE WHEN created date >=…
-
Filter option
We have created a dashboard that will be embedded into our company website and will be public facing. I wanted to know if there is a way to remove the option of being able to click into the card and give the option to filter or show segment options. I have tried editing the dashboard by removing all interaction and filter…
-
Need help with Beast Mode for specific time period
I'm trying to create a beast mode that calculates revenue for jan-jun and then july- dec SUM(CASE WHEN Month(Period) = MONTH(CURDATE()) -6 AND DAYOFYEAR(Period) <= DAYOFYEAR(CURDATE()) and Item THEN a_amount END)
-
New nested statement
I Need to create this nested statement in the Domo Dataflow but I keep getting a syntax error. I tried doing it a few ways and both are creating errors SELECT CASE WHEN "Status__c" in ('Booked') AND > 111 THEN 'TIER 4' ELSE 'TIER 1' END FROM "sfdc_travel_raw" or this query SELECT *, SUM(case WHEN "Status__c" = 'Booked' >…
-
Nested Case Statement
I'm trying to count travel records that are completed and then put them into tiers. · 0-34 Tier 1 35-70 Tier 2 71-110 Tier 3 111+ Tier 4 I keep getting an error using the beast mode below CASE WHEN SUM(CASE WHEN `Status__c` = 'Booked' THEN 'Completed' ELSE `Status__c`END) > 35 THEN 'TIER 2' WHEN SUM(CASE WHEN `Status__c` =…
-
beast mode for specific date range
CASE WHEN `end_date__c` >= '1/01/2021' and `end_date__c` <= '12/31/2021' then `2021` else 0 end getting an error message Calculation Error : A column in this calculation did not exist.
