Best Of

Thank you @GrantSmith - Your advice is what solved this for me.

As suggested by GrantSmith, I created an excel upload dataset with a file that references our 4 digit YYWW to every calendar date in that week. Here is a sample of the spreadsheet used to create the date conversion dataset:

The dataset was created by uploading the excel to DOMO:

The card I was creating was already using a Magic ETL dataset:

At the bottom, you can see where the date conversion dataset is coming in to the existing dataset that was already almost what was needed. DOMO didn’t automatically identify the MMDDYYYY fields coming in as dates, so I put in the “Alter Columns” module to change the properties of these fields to an actual date data type:

Since there were 2 YYWW fields to be compared, added 2 joins. Each join was configured similarly to associate a YYWW field from the main data to the newly brought in MMDDYYY date formatted data:

Important note: With the second join there was a warning that there were duplicate field names, which forced renaming them to something different on the 2nd join. I chose to name the field in a way to reference to the respective column to make it easier to tell the difference later.

Used a Select columns module to rename and move the new columns to a place that made them easy to use later and rename them:

Looking at the dataset, there are now 2 places where there is a MMDDYYY date field which correctly corresponds to the YYWW date in the neighboring column – Note, I chose the Sunday day of the week on both as our systems update on Sunday making it the most relevant date to choose – any date would have worked though as we are only trying to get a count of the difference in the number of weeks.

Which now makes the beast mode super easy to write for the card:

And gives a result we can display and use for filtering:

Thanks again for pointing me in the right direction, Grant!

Brent Jensen

Bass Pro Shops

Merchandise Operations Analyst

@Brightsider you can but you would have to restructure your dataset. You'd need a single date column to filter off of, so you'd want to pivot your data to create a single date column, and then have a new label column that holds the value of "Created" or "Scheduled"

@newbee do you have dataset access? You can get this from the Domo Governance connector using the "Beast Modes"report - then you could create a view on top to filter by the dataset you are concerned with.