jaeW_at_Onyx Coach

@GrantSmith could you do something like sum(1) as daily_record_count, avg(sum(1)) over () as 60_day_rolling_avg , ( sum(1) - avg(sum(1)) over () ) / avg(sum(1)) over () as percent_Change FROM ... WHERE DATEDDIFF(date, current_date()) between 1 and 60 GROUP BY date EDIT:: pardon my pseudocode, i'll try to test later.

You can use beast modes in filter cards. You can't use aggregations, sum(amount), in filter cards because that would require the ability to filter on the HAVING clause (which is a feature switch that's not enabled by default, talk to your CSM!) Side note about said feature switch: - Export to excel and PPT is not supported…

Hey Martin, If i had to guess you have an error in when your beastmode evaluates the concat. Can you confirm that Round(BeastMode*100,2) delivers the expected result in a table card? Does your CONCAT function wrap an aggregation or does it evaluate at the row level? consider the differnece between: concat('text',…

Instead of trying to use drill paths to solve this problem, could you use filters? could you structure data where you have a column where you pick between 'day, month, and quarter' which then filters the data to the range of dates you're interested in seeing? if you must have different views with different groupings in the…

it's unclear to me what you mean the rows are duplicate. does the underlying data actually contain duplicate rows? or do you mean, you have more cards in your visualization than you expected? If it's the later, i'd guess you have Date in Sorting (or a similar period based column) I'm guess that because adding a field to…

@eric_etumos wrote:It looks like a simple syntax issue: 100 * (SUM(`revenue`) / SUM(CASE WHEN `day` = '01/01/2020' THEN sum(`revenue`) ELSE 0 END)) EDIT:: i need to read everyone's responses before i start replying ... looks like @GrantSmith beat me to it... The ELSE clause is a red herring. If you take the SUM of a column…

Tricky! But dangerous if the changes are not transparent. Consider using the fiscal calendar .https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/KPI_Card_Building_Part_2%3A_The_Analyzer/Using_A_Fiscal_Calendar Keep in mind, using a fiscal calendar DOES NOT change how DATE functions in Beast modes evaluate.…

@Cartergan wrote:You can try limiting the data rows and see if this achieves the result you are looking for. In the analyzer view near the bottom right of the screen you can set how many rows you'd like to show, and then you'd need to sort your results how you'd like them to appear. I would be unsurprised if this method…

Two thoughts here, While you CAN save a copy of the cards onto a new page... I probably wouldn't. This creates a maintenance nightmare that you don't want to think about if you end up with 3 or 5 dashboards that are 'different views for different departments but functionally the same information.' Instead, consider using…

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