jaeW_at_Onyx Coach

@leonardschlemm , what @swagner gave you is called a window function. this is a common implementation in SQL which can be googled! assuming you have cashiers on the axis, you should be getting that cashiers sales as a percent of total sales. if you want that cashiers sales as a percent of store sales or some other subtotal…

@lwang , all these options are ... ok, but if it were me and i HAD to have an alert, i would use a recursive query to construct a dataset that captures my alert conditions. so whatever your 'system health' stat is, generate one row per day of the stat, or generate a dataset of the conditions that triggered the alert then…

SUM((`PAYMNT_DUE_DT`-`INVOICE_DT`)*`RECPT_AMT_USD`)/ SUM(`RECPT_AMT_USD`) I don't believe your problem is the existence of zeros. Or att least, perhaps not the way you're explainig it anyway. 1) i assume payment_due_dt is a dateTime column. If so, you shouldn't do dt-dt, I'm not sure it's reasonable to assume that Domo…

+1 to @MarkSnodgrass It is tempting for SQL developers to want to use MySQL and Redshift (and fair enough Magic may not seem intuitive), but it keeps the SQL developers as the bottleneck both in performance and distribution of workload (they become the only people who can implement changes on dataflows) -- job security,…

@user013818 , DO/WHILE loops are EXTREMELY inefficient in SQL (and therefore at best we'll call it an Anti-Pattern). Window functions will approximate DO/WHILE behavior. Can you be more specific about what you're trying to accomplish?

Don't JOIN Budget to Actuals. APPEND Budget to Actuals. By Appending you'll avoid duplication and can avoid 'crazy math'. https://www.youtube.com/watch?v=PVbOeLSae9o&t=18s

@DataSquirrel domo datasets are CSVs stored in a data lake environment similar to S3. "I'm a bit surprised to hear that what I'm asking isn't a straightforward question, but, actually, maybe that makes sense. Architecture <> Mechanics." There are books on building performant data models in powerbi. I recommend having…

If you're looking at Data Distribution (especially as a monetized service) Domo does have a suite of tools under the umbrella "Domo Everywhere" The video below is a take on a specific product "Domo Publish" which is possibly a lot more than you're looking for. If you just want to send your customers data 'drawn from domo…

Domo has always had a database layer called Adrenaline (it's what the cards in analyzer are built against)... they just ... don't always document their stack in a way where tech nerds can know what stuff is called :P Magic 2.0 is a MASSIVE improvement over the previous version in terms of performance and speed to create…

lol @DataSquirrel, the scale of your question is a consulting engagement with a Sr. technical consultant at Domo ... or a TSM maybe. Just sayin ;) 1) i would evaluate if Magic 2.0 can meet the requirements 2) you could try going the UPSERT route, but you would still have run your data through logic to flag soft deletes. (i…

Sounds like you'll either have to 1) change your data before it comes to Domo 2) wrestle with connector settings 3) fix it in ETL. Here's a tutorial outlining the 3rd option. https://www.youtube.com/watch?v=cOiT3FjQ7K8

@DataSquirrel , seems like this is an extension of your other question. What do you want to do? are you trying to query tables or administer your instance of Domo? Domo does have an ODBC driver but it is a premium feature https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Other_Methods/Domo_ODBC_Data_Driver I hear…

"Domo Query Language" :P @DataSquirrel what are you trying to get done? There isn't a repository of DQL syntax anywhere AFAIK unless you get it from the developers. DQL is similar to SQL insofar as it's just a language for addressing Adrenaline (database layer). So ... the question boils down to 'what do you want to get…

@ST_-Superman-_ 's solution works most of the times. if it's unlikely that the total number of rejections would not be the same from day to day, THEN you can build an alert on it. Imagine Trans_ID 16 was rejected. then today it goes to approved. Meanwhile Trans_17 goes from approved to rejected. Net change = 0. Disaster.…

@user028768 , It looks like your text is actually MarkDown formatted... which is not the same as HTML and if it were me I would google and see if there are any other developers who've writtend out regex to convert MD to HTML tags. Or maybe I'd run the data through a python package and then push it to Domo (via APIs)…

IMHO before seeing Tag Manager implemented, it would be necessary to have better tag integration into the user experience. Search across all assets by tags have tags auto apply from source through ETL down through cards and dataset views. Without more thorough integration and in product support that doesn't rely on the CLI…

oh my goodness yes please. the lack of JOIN on a BETWEEN forces users to do nasty cartesian product joins OR forces them to use other ETL tools.

Page filters is not the same as securing sensitive data. Have a look at PDP policies, https://knowledge.domo.com/Connect/Personalized_Data_Permissions_(PDP) , for properly securing data. Any other method is literally a case of WHEN someone accidentally gets shared the wrong content, because that's all that's stopping…

How much data volume are we talking here? How frequently are you updating your raw data in Domo? This video is a little less polished than my usual content, but here's how you can enable upsert using the CLI. It doesn't matter if you use Workbench or CLI, the considerations outlined in the video are the same.…

@JasonAltenburg make sure to put the idea in the Idea Exchange. I promise to upvote. :P https://dojo.domo.com/categories/ideas

contact your CSM / Domo Account Representative or support@domo.com and ask them to push the Magic 2.0 beta. it's free and available if you ask for it.

@user065217 i have no idea if WB can access URL links, i'm just proposing a solution that will work. WB can be configured to only execute when files are modified. (just search for update, https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Scheduling_a_Job_in_Workbench_5_(with_new_features))

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/KPI_Card_Building_Part_2%3A_The_Analyzer/Setting_Color_Rules_for_a_Chart

@user065217 if this is a short term fix, why don't you just download the file instead of trying to pass a URL? also it looks like sharepoint has native functionality for syncing files with a local machine ... https://support.microsoft.com/en-us/office/sync-sharepoint-files-and-folders-87a96948-4dd7-43e4-aca1-53f3e18bea9b

@AJ2020 is this a duplicate post? or did my lengthy response not come through (sorry i thought i answered this last week). EDIT:: totally misread your requirement.

@GrantSmith and @MarkSnodgrass i love both of your solutions (especially the regex!) if it were me, I would have done something like, CASE WHEN <text contains 3 colons> then text WHEN <text contains 2 colons> then concat 00: END then use TIME_To_SEC

@akshayaviswanathan , there is no 'easy' way to do what you're asking for. @GrantSmith 's method of using the beast mode manager works IF the beast modes have been shared to the dataset (because then you only have to update one beast mode). if you didn't share the beast mode to your dataset, then do so. and then edit all…

you cannot set background colors on header columns and rows. in the standard table chart type, you can apply HTML formatting to your beast modes, https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Adding_Graphics%2C_Links%2C_and_Images_to_Table_Cards_Using_Beast_Mode @LMS…

... so use an order by clause on quarter if you want it to sort by quarter.

... do you have quarter in the order by clause?