pauljames Contributor

@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.

@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. 👍️

@ColemenWilson

No. I don't.

@ColemenWilson ok, i think we are close. still not working though…we've got dates returning

@ColemenWilson

@ColemenWilson , i don't see this beastmode available.

@ST_-Superman-_ , @GrantSmith , @Ashleigh . Y'all rock! Thanks for all the helpful tips and insights!

@Jones01

@Patricia_Zavisky In the etl perhaps you could use an add formula file and name the column name then in the formula write this…. IFNULL(column name, 0)

Hi @jena ! Have you looked into the predictive tiles or automl yet? You would need a healthy amount of rows to train your dataset for autuml.

Sometimes I feel like the Domo community are all about to ask the same question at the exact same time. lol Thanks for the answer guys!