jaeW_at_Onyx Coach

@swagner , Any columns you use in your WINDOWED functions must appear in the chart. In the example below you're partitioning by the contact of YearQuarter and sorting by order date... therefore you must have date represented in the chart else it tries to SORT on a column that doesn't exist. (I believe) Try this, go back to…

@GrantSmith and @Neeti, you could use the Java CLI + techniques shared in this video to point the output dataset of an ETL at a different dataset. ( cc @DataMaven )

Agree w/ @GrantSmith , IF you can transform the data as you bring it in via connectors or workbench, that would be the easiest way to add the column to your data. Downside is, there's no visibility of that calculation to the business user (whereas MySQL or MagicETL processing steps makes the process transparent). It is a…

Please make sure this gets submitted as a support ticket if you're confident this is a bug. From there the Domo team can escalate the issue to the connector support team who ... support connectors! It also may be of interest to see if that behavior is echo-ed in the Beast Mode Manager once it's released.

Do you have a screenshot of what you've gotten done successfully? Can you use a pivot table to display multiple metrics? Which part are you struggling with? For the part about % change compared to prev month, it can be a struggle if you're using Date filter to explicitly filter on 'last month' b/c you're filtering out data…

I personally am not the biggest fan of the Left Side NAV b/c I'm too lazy to manage it. You could make a Default Page as previously suggest, but embed either Table or Image cards that act as a Directory. Think a Picture who's Dashboard Interaction is set to LINK to the Finance page. Alternatively if you build an 'ugly…

are all the datasets in Domo Workbench jobs? Do you own all of them? Did you set up all the jobs on THAT machine? https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/13Workbench_5_FAQs check the documentation Can I save Workbench jobs to a shared folder? I want multiple users to be able to access and…

literally trillions? if you're dealing with trillions of rows of data, don't use a web connector. they just weren't designed for that kind of heavy load. instead consider the JavaCLI or Workbench to support data ingestion. Why? B/c both of those workflows can accommodate data uploaded in batches (multiple CSVs) which is…

sorry ... what do you mean by 'dynamic date ranges'? in what context are you applying this? my standard response when users are trying to build heavy calcs into their beast modes or ETLs is to say, build a date dimension ( a table with one row since the dawn of time and add attribute columns like year and month, and in…

@GrantSmith , It seems like you're recommending this complex flow b/c MySQL doesn't support an OUTER JOIN. You can emulate an OUTER JOIN by UNION'ing a LEFT and a RIGHT JOIN. (remember that a UNION will remove duplicates SELECT a.`Week`, a.`Advertiser`, a.`2019 Revenue` b.`2020 Revenue` from `2019` as a left join `2020` as…

I addressed this problem in another post: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-can-I-group-multiple-columns-by-year-month-in-the-dataflow/m-p/47684#M8126 use the lag() function

careful of just considering the MONTH of the date. You'll combine years in cross year analysis. add YEAR() comparison to the beast mode. to combine year and month i do year()*100+month()

@MarkSnodgrass and everyone else... stay tuned and check the next set of release notes ... there maaaaaay be a feature in the pipes that can help with your use case.

i'm reasonably confident the future values are extrapolated in the card engine (but not the data engine). it might be of interest to see what happens when you export the card data (as opposed to the export dataset) , but i'd be unsurprised if that didn't work. i know it's more work, but if you are interested in the…

it's possible but not with the standard cards in Domo. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/KPI_Card_Building_Part_2%3A_The_Analyzer/Creating_a_Map_with_Regions each block on a map (whether state, county, region) is just a geometric shape which Domo associates data to. So instead of long /…

Be careful with this approach. Keep in mind that year 2019 may end in the middle of Week 52. Make sure to test and verify how that plays out in your GROUP BY statement. ex if Jan 1 2020 was a Wednesday then 12/31/2019 would be Week 53 2019 1/1/22020 would be Week 53 2020. When I have to deal with weeks like this i usually…

can you send a screenshot of where you're running into problems? it's unclear to me whether you configured a workbench job without a title for the dataset. or if you added a title to the dataset but aren't seeing it in Domo.

Sorry, are you using web-based connectors or workbench to move the data? If you're worried about blocking SQL Server, it might make sense to schedule exports from SQL Server as CSV files and then move the files into Domo via Workbench + CSV connector.

Is there a reason why you can't generate this information in a Card? do you have a screenshot of the work you've already done? there is a GROUP BY tile in MagicETL and standard MySQL will work as well.

Sorry, I thought I replied. Ask your CSM to enable 'window functions in beast modes'

How to build a correlation plot to compare multiple variables!

you CAN do a lag function in Analyzer! Youtube video explanation: https://youtu.be/cnc6gMKZ9R8 lag(sum(`Measure1`)) over( order by year(`Date`) * 100 + WEEKOFYEAR(`Date`) )

I just posted not to use a Recursive Dataflow. But if you're hell-bent. Don't use a JOIN to combine historical and new. Use an APPEND (b/c JOINS in MagicETL are slow especially with composite keys). Add a Row_Number() function via the RANK / WINDOW'ed tile where you number the rows based on how you define a duplicate row…

Sorry late to the game! But my ten cents. Don't build a recursive dataflow. Yes, a recursive dataflow will work for your use case, but recursive dataflows don't scale with data volume. If we're talking 100M+ row datasets, you'll start having to wait in excess of 20 minutes to i've seen 5, 10 and 23.999 hours. (23.999 b/c…

You can alter dataflows if you know how to monitor network traffic and send curl requests. OR you can update the JSON definition of a dataflow using the JavaCLI (my recommendation over CURL or Postman) and the list-dataflow command. This is definitely one of those ... use at your own risk kind of things. Creating a…

Clarifying question. Do you actually have future dated data? You could do something like date_format( `target_date`, '%Y-%m') to group your dates by yearMonth number and then take the count of each row, just to verify that you have future dated data. Assuming you do, you can follow @GrantSmith 's tip with a small twist If…

in the enumerator you only keep columns specific to engagement (in my case just libraryID b/c that's the PK for the table, userID, contentID and count_numerator.

Oh no!! Dang it. I'll have to record it again tonight. Sorry.

Gotcha covered @WizardOz , EDIT: updated with sound: https://youtu.be/Xb4QgKYgaqg the short answer, you want to create a dataset with the granularity one row per user per content. then JOIN it to the rows of actual engagement. that way you can calculate did a user engage or not and take the ratio. this model does not use…

can you make a new dojo topic for this? I LOVE THE QUESTION and am happy to dig in... but just to keep things separate.