jaeW_at_Onyx Coach

https://developer.domo.com/docs/dataset/overview-5 use the dataset API to extract your data from Domo. you can't use a table card as your datasource, but you could use the dataset view (domo beta feature, tlak to your CSM) to create a VIEW of the dataset and then source that data via API. Alternatively (and this is what i…

create a Beast Mode ... this is pseudo code. Case when Date >= today - 30 then 'Group 1' when date >= 60 then 'Group 2' ... END Alternatively if you're using this logic a lot, build a date dimension ( a table with one row per day) in Magic or SQL and then add the '30 day trailing' column with similar logic from your beast…

AFAIK, no. It's a security risk Domo is unwilling to expose their other clients to. Your options are to transfer your data into Domo for storage & visualization ,or take advantage of the (premium) federated query solution, https://knowledge.domo.com/Administer/Other_Administrative_Tools/Using_the_Federated_Data_Solution…

OOOOOH i get it now... i read this a few days ago and i didn't understand teh requirement... if i understand you correctly, COLUMN, contains values like "Joni Mitchell LLC", "Thomas Flynn LLC" and you just want to agregate it to LLC. Yes. Use a beast mode CASE WHEN LOWER(column) like "%llc%" then 'LLC' else 'Not LLC' END…

@SLam sorry ... i don't understand what you're driving at. COUNT(DISTINCT() ) counts... the number of distinct values. so the number of unique order no is 4. if you want to know 'how many errors there are, don't do a count (distinct) just do a count... that would give you a total of 5. when you drill down, if you want to…

also... don't split hairs which order columns are added to your dataset. neither analyzer nor ETL tools really care about column order. if you want to reorganize them for display purposes, just use a DataSetView (talk to your CSM) to reoganize them.

this may lead to problems down the road. if you design a dataflow that injects columns based on the number of orders (prod_1, prod_2, prod_3) then you can potentially get a dataset with 100 extra columns. from day to day, the number of columns might change based on the data in your dataset. as a result any downstream ETL…

if you have a consistent list of IDs you could make a beast mode CASE WHEN id in ( ) then 'keep' else 'toss' end OR maintain a list in a webform and then JOIN your webform to your dataset.

better solution would be to avoid doing a GROUP BY in ETL alltogether and just APPEND the data. (make sure to align columns with common field names). then in analyzer you can use beast modes to just SUM() or COUNT() the metrics of interest. the proposed solution is superior b/c it allows you to filter on all the columns…

What's your entire question? Domo's redshift executes in a full-fledged Redshift environment, so of course, what you're asking for is possible... in Redshift on most days of the week, you don't want to write an INSERT statement into a table b'c, it'll typically be faster to just restate the table, SELECT ... , with all the…

I have several videos on my YouTube channel https://www.youtube.com/c/OnyxReporting_2/playlists around handling Date aggregations in Analyzer. If you're looking for a freelancer to help you with this, I do offer hourly consulting services at 150USD / hour. You can DM me at jae@onyxreporting.com

does this video help address the thing you're trying to solve. https://www.youtube.com/watch?v=9uNv1_0XXao honestly, it's a bit complex for your use case. you could just make a beast mode case when card_ID in ( ) then 'keep' else 'toss' end then use that to filter your card. if you put 'user' on the axis, you know ever…

https://knowledge.domo.com/Connect/Personalized_Data_Permissions_(PDP)/PDP_Policy_Autocreation @rhollander , take a look at this utility, may help you automate the process

It sounds like CLV is derived from transactional data. I assume something like SUM(SalesAmount) to reuse CLV you could create a Dataset View (beta feature, ask your CSM) with two columns, Customer No and CLV and then JOIN it to your other dataset. I think that's an inferior solution, but probably what you're currently…

it's not a mistake in Domo. The first week of containing dates in January starts on a Friday. If your week starts on Sunday, then your first week would only have two days (Jan 1 and Jan 2). What you want to happen is you want Domo to 'just know' that Jan 1 and Jan 2 belong to the last week of December... which is business…

use Magic ETL 2.0. I assume your data arrives with generic column names "column 1", "column 2", "column 3" add FILTER tile to exclude rows where "column 1" = ... you'll need 3 sets of filter rules to exclude the first row, the second row and the row containing Total. then use the ALTER tile to rename tiles and set the…

this is a very frequently covered topic on the Dojo! no worries ... you're not the only one... although... it may help to search first... LAG() (and all the window'ed functions) are available in Domo if you ask for the feature switch to be enabled, check with your CSM and ask them to ("enable window functions in beast…

exclude (FILTER) rows where column = "totals" and column 3 is null. ideally you'd be able to configure your file connector to ignore row 1 and set row 2 as the header. is that an option? otherwise you may have to also filter out row 2, and then set the remaining rows using a SELECT statement and then set the DATA TYPE with…

Updating for posterity b/c this issue came up recently. In cases like this, the issue is NOT a domo issue rather it's a Windows Security policy setting, so the best bet is to collaborate with your IT/IS administrator. OR do google searches without "domo" related keywords.…

On the job board you can find freelance consultance who can support short one-off engagements like this request. https://dojo.domo.com/t5/Job-Board/Freelance-Domo-consultant-available-for-hourly-and-long-term/m-p/48595#M44 In the immediate term, to troubleshoot: take a dataset with 5 rows of data that you absolutely know…

yes. just use standard MySQL 5.6 syntax.

AWESOME WRITEUP. KEEP IT UP! We really need more content like this when i copy paste this into postman I get a good response. curl --location --request POST 'https://<>.domo.com/api/content/v2/authentication' \--header 'Content-Type: application/json' \--data-raw '{ "method": "password", "emailAddress": "<>", "password":…

Agree with @GrantSmith ... the warning is right there in the message. Imagine if the option wasn't there. Then users would have to take several additional clicks to delete a card... Obviously no one reads popups ? so you do have a few options 1) you can LOCK a card so that only Admins and People who own the card can alter…

? ok... so ... tradesies. i'm taking the time to help you. in exchange, i'd appreciate it if you do a writeup for the community that steps through the final (anonymized) script you develop. deal? what you're encountering here, is the difference between using a public vs a private API. hence why it's asking you for a…

You can use the SQL transform if you choose... but I recommend against it. the "Add Table" transform does a lot (and you can add index via the UI) but unless you're doing large JOINs adding Indexes can cost more (in time) than just SELECT into table. Ideally you want to build dataflows that you can easily hand over to a…

sounds like a crap answer but at htis point i'd suggest popping it over to support@domo.com but also, take Start Date off the axis, you have to be positive that the beast mode stands on it's own without an additional GROUP BY clause.

There's also a Quick Start that deploys a ton of cards to your instance related to Domo Stats. Might be worth using that as the jumping point.

@Khan_Naziya also... PDP implies logging in... is it fair to assume your social users are logging in to Domo?

https://knowledge.domo.com/Release_Notes/Feature_Release_Notes/Social_User_FAQs_and_Videos i don't do much on the security side ... are they getting to the cards via Buzz as the KB says they ought to be able to?

so much going on here. there isn't necessarily a difference btwn using the APIs versus the CLI. the CLI interacts with Domo by passing commands to the API framework... so it's theoretically possible that you are doing the exact same thing. "which one is better?" it depends. how good are you at managing your API calls ?…