jaeW_at_Onyx Coach

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?

@user066906 the code that everyone gave you is correct. the problem is in your understanding of your data and how you're testing your data. if you can't identify your data with s not null and empty string, then it must contain SOMETHING that you aren't testing for. figure out what the something is. alternatively, post a…

do you have Year in the ORDER BY clause? if so, then Q2 could be from different years. remove everything from your ORDER BY / sorting section of analyzer.

@LMS , in the future, please be specific about what you're unable to accomplish (other than 'everything') it seems like you're asking us to provide consulting services -- which i don't think is a reasonable ask from the community site in my opinion. you can calculate cumulative sales in your ETL or you can do it in…

It happens, unfortunately. Try refreshing your page and recreating the card. If you have Beast Modes saved to the card that do not validate, this can cause problems, so make sure they are all good.

@AJ2020 so... instead of having the denominator be the grand total by item you want to subtotal by item and month Window functions are not unique to Domo. It's a common SQL thing. Here's some documentation so you can understand syntax sum(sum(amount)) over (partition by item, month)

Hey @MarkSnodgrass , i think i found this video of you explaining how you created that ZIP file!! :P Side note we should put that in dojo-domo. https://www.youtube.com/watch?v=eKOLhsfl10Q

support ticket :(

@GrantSmith when you write the index_o we should give it an explicit column name first?

@user066906 are your invoices and payment records on the same row? or are they spread across rows? if it's spread across rows these solutions we're proposing won't work for you... so ... make sure to double check. @MarkSnodgrass 's checks for is null OR is blank are perfect, but just do the opposite check as proposed by…