pauljames Contributor

Hey @verytiredgirl! The user will be able to do this in the filter card or filter at top of dashboard themselves. You can remove the last line there. CASE when channel_id = 1 THEN 'Facebook' when channel_id = 2 THEN 'Instagram' when channel_id = 3 THEN 'Tiktok' ELSE 'Others' END

@Anna_Otake hey there! I'm late to the party here but just to piggy back off of what Michelle mentioned. If you go to the People Report in the Domostats connector (maybe refresh once a week?), build a simple table card off the dataset, then setup a scheduled report for the sending cadence you want and select the report…

@MayaU_01 , hey there! yes, i've typically only been able to apply a card alert to a metric that changes over time and could be applied in the summary i.e. 100 Active Accounts or 2.1% Churn, etc. What you could do is create a card and save your filtering that you want to that, then apply your alert logic to that filtered…

@TJacobs , i tend to take care of columns I know i'll be having calculated fields with in their etl by using the formula tile. LOWER('Status'). this way you don't even have to think about this later down the road. You could also do it in the beastmode itself before you apply your logic. SUM(CASE WHEN LOWER('Status') IN…

@Sbhatia , yes to Marks point there could be a sorting issue on the card causing duplicates in the table. I'm guessing that there are multiple countries behind those regions causing the dup rows? try this. SUM(CASE WHEN Metric = 'Orders' AND Relative Week = -1 THEN Value ELSE 0 END) FIXED (BY Region, Country)

@scpradhan this might be insanely simple answer. But most of the time when I'm fighting GA4 discrepancies between platform and Domo connector it comes down to filtering on specific properties i want to see and report types. Your platform view in GA4 might have filters applied or vice versa. For me, its about directionally…

@jrtomici , hey! have you tried taking a look at your instance governance settings? Perhaps there is a role limitation the user has?

@DanHendriksen, Huge fan of the AI series! I’d be really interested in use cases where agents help with observability — like detecting pipeline failures and actually making decisions or triggering remediation steps. If an ETL flow breaks or data doesn’t update as expected, can an agent diagnose the issue or kick off a…

@kim_barragan0126 , Hey Kim! Did you save and run the ETL? A basic question, but sometime folks forget. (I know I have). Can you share a bit more on what exactly you've done? I can help you work through the details.

@Jessica_Davies , we had trouble, but then reached out to our AE who connected us with an internal Domo contact. Helped us connect and walked us through each step. :) I suggest reaching out to yours.

That's a great idea. But what about the trigger value change that would prompt a scheduled report send?

@dlc3 , what does the beast mode look like then that references the 28_DAYS_FROM_VARIABLE beastmode?

@ColemenWilson CASE WHEN MAX(Date) - INTERVAL 28 Day THEN pos_quantity_this_year ELSE 0 END?

@GrantSmith how would I write a case statement to categorize 2024-03-30 to 2024-04-05 as CW10?

it was the append option at the output file. Now I know that’s a thing. :) we have a few of us working in the same etl at the moment and it was selected without realizing. Thank you all!

@DomoDork @MichelleH @Godiepi any reason why an input of 5.1k rows turns into an output of 318k rows? I think this is the root of the problem… I'm just putting the file inside magicetl and creating an output…and for some reason that adds a ridiculous amount of rows…mostly new null rows I'm seeing. any answers as to why?

@DomoDork , yes even after apply ifnull() I'm still getting an insane amount of null rows returned. The input dataset is only 5.1k rows, but then after appying ifnull() I'm getting ~200k rows returned. It's very strange. Any others out there?

@ArborRose , thats not the connector. https://domo-support.domo.com/s/article/000005386?language=en_US

@n8isjack when i take the difference between this year and last year, i'm not getting YoY returned…

@MarkSnodgrass, it was informative! But, it's not really what I'm looking for here.

It's called an OLAP query. @ArborRose

I'm using an excel file that is a pivot table, it needs to stay in this pivot table view since i'm connecting to an internal data warehouse. Would that have anything to do with it?

Wow, didn't know that was an option. Thanks Grant!

@SituationLisa @MarkSnodgrass @Strostle @Hydrow_Eric I just tested again, looks like spend in coming in correctly however conversion value and conversions does not return when selected… Ticket has been submitted, escalated.

Having the same issue!!!

If I enable to apply to all cards, then I lose the drill in place function I want. Yes, all names are the same, However the zip, once clicked, is not listed to the top.

I'm pumped! This is my first Domopalooza 😎

@MichelleH thank you!

@DashboardDude , we have a merchant ID. 👍️