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(`Im…
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…
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 hav…
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…
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 …
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 …