-
Need help with CASE statement in beast mode.
I'm getting this error on a pivot table card. The grand totals are correct but I need to see them by data source (Row) Here's the beast mode I'm using: CASE WHEN `Product` != 'SEM' THEN SUM(IFNULL(`Impressions`, 0) / 1000 * IFNULL(`Monday.CPM`, 0)) ELSE SUM(IFNULL(`Cost`, 0) + IFNULL(`Cost` * `SEM Fee`, 0)) END I've also…
-
How to create DoD variance formula
My data set has 'Total Actions' by advertiser, by goal name, by day. I would like to be able to create an alert when 'Total Actions' drop to 0 on a particular day (where it previously had >= 1). Of if there is a variance of 90% or more. As I understand it, we can create alerts on a card but only based on the Summary…
-
Calculating a % based on multiple dates
I would like to create a beast mode that calculates the % of the way we are into a campaign. In Excel, I would calculate this as =(TODAY()-'Start Date') / ('End Date' - 'Start Date') Here's what I have so far (I want this to return a %): (SUM(IFNULL(CURDATE(), 0) - IFNULL(`Start Date`, 0)) / NULLIF(SUM(IFNULL(`End Date`,…
-
Formula help: Adding 2 columns that meet certain criteria
I am trying to sum up 2 columns that meet certain criteria and would like to create a new column with the values. Here's what I have so far: SUM( CASE WHEN Goal Funnel Category = 'Interest' THEN Total Actions WHEN Page Funnel Category = 'Interest' THEN Total Actions ELSE 0 END ) I am getting the error below but wasn't sure…
-
Cleaning date column which has text
Hoping someone can help me with this. I want to ingest csv files from our S3 bucket where the first column is the date column. That column also has text in it: I am also getting this error "Failed to parse text '2/1/23' from column 'Date' as type 'Date'" from one of my files. I've tried fixing the file itself but it's not…
-
Is it possible to pull in animated images (GIF) to a table card?
I have a card where I pull in images. I have links to the images in a google sheet which I connected to Domo. Most images are being pulled in. I noticed that the ones not being pulled in are animated GIFs. Can these be pulled in at all? Here is the HTML I'm using: CONCAT( '<img alt="img"…
