Salmas Member

@MichelleH That's ok, no worries. Now I got it. My bad! In the campaign column my campaign name was in capital letter and in the formula I was using small letters! That was the problem. Now I changed it and it is working now. Thank you for checking.

In the select column we can change only the headers not the rows

@GrantSmith It's working. The function wasn't showing in the beast mode, but I tried running it. It's validating. Thank you

Hi @GrantSmith I wanted to keep both the rows separate. Also I checked for COALESCE function is beast mode, but it's not available for me

Hi I was looking for a execution state for datasets only. I got the status of dataflow from Domo Governance, but looking for the same for dataset from Domo governance only

Hey @GrantSmith Is there any way to get the last execution state of all the dataset as 'Success' or 'Failure' or 'Running' from the Domo Governance Dataset. I wanted to see which datasets are successfully ran and which are failed. Looking forward for a solution! Thanks

Hi @Ashleigh I tried both the ways earlier itself, but that wasn't working.

Hi, I'm facing a similar issue. In my case, I wanted to see the difference between two dates in the same column. I have a Rank column also. I have used the beast mode calculation as (Case when 'rank' = 2 then 'date' end) - (Case when 'rank' = 1 then 'date' end) But this is not giving any data, the output is just blank. Let…

Hi, I'm also facing the same issue. I wanted to set the range of a metrics (datatype is '123'). Usually we show this metrics in a aggregated level (Sum). But the output of the beast mode is not showing correctly. Any solution for this?

Hi @GrantSmith , Thank You

Thanks @GrantSmith , it's working

Hi, Agree to your point. And that was a mistake. SUM(CASE WHEN (`Day`) = (MAX(`Day`))-1 THEN `Visits` END) what about this statement?