-
Can't find beastmodes to add to AI dictionary
I would like to add beastmodes to our AI dictionary. I have saved (in analyzer) all our beastmodes to the dataset I'm using but don't see them as options when trying to add columns in our Ai Readiness page. What step am I missing?
-
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"…
