-
Can we do unpivot functionality in ETL, in the beast mode?
Hey, I wanted to unpivot two value column, let's say, A & B, in which the first column gives A,B (row wise) and the second column gives its corresponding value. Thus, I can use the first column as filter and value column in the card. When we select either A or B, then the values in the card will change according to that.…
-
I wanted to rename few items in a column based on this campaign, in the ETL
Hi, I wanted to rename App to Web for this campaign, and I tried using a formula to achieve this in the ETL. Here is my formula CASE when campaign = 'CM1' then 'Web' else channel END But this is not giving me the expected output. Could anyone please help me with this? I actually wanted to achieve this in ETL only, not in…
-
Can we use Partition by function with Case statement in beast mode?
Hi, I wanted to achieve the below screenshot data via beast mode. For each token id, whichever column (B,C,D) has non zero value, in the Merged column, I wanted to get that value. I tried case statement, say Case when A=0 and B=0 then C when A=0 and C=0 then B when B=0 and C=0 then A end This is not giving me the correct…
-
Is it possible to create an alert with a values lies in two column?
Hi, I'm trying to create an alert by comparing two values lies in two columns. Here is the example Date column A Column B Jan 7 88 90 I want to set up an alert , when Column A < Column B and the message should be coming as 'On Jan 7 , the Column A value was 88 and Column B value is 90' I have tried for different chart…
-
AND function is not working in the case statement for a single column values
Hi , I'm working with the Domo Governance dataflow, and I wanted to create a card which shows a message based on the successful update. I have 4 dataflow A,B,C,D. I wanted to see a message 'successful', if all the 4 dataflow has ran successfully today. Else it should should show a message 'Pending'. Here is my beast mode:…
-
Alert message for card is not supporting the card filter
Hi, I am facing an issue with the alert message. In the card, I have a filter for date, which is 2 day lag from current date. So that I wanted to get the alert by showing the data for 2 days lag. I have checked the option for filter in the alert rule part and even though when data gets updated, the alert is showing the…
-
Can we create a beast mode calculation with case statement for a value field?
I wanted to set the range of a value field like, case when 'value' <=1 then '0-1 end from this range, I wanted to see the count('dimensions'). I have tried this in beast mode, but not getting the correct count for each range. Any help is appreciated Thanks in advance Salma
-
Show last 12 months dynamically using beast mode calculation?
I wanted to show last 12 months from June 2020 - May 2021 dynamically using beast mode calculation. Any help is appreciated! Thanks in advance
-
How do we calculate current day Vs Previous day in Domo.
SUM(CASE WHEN MAX(`Day`) = DAY(MAX(`Day`))-1 THEN `Visits` END). I tried this, but this is not working
