jaeW_at_Onyx Coach

@JasonAltenburg how big is your dataset? using SQL to create a word document matrix is a little square-peg-round-hole-ish. I built a tutorial around a similar topic here. http://www.onyxreporting.com/blog/domo-parsing-json-in-a-mysql-56-dataflow the SQL is actually creating tables, but may not run as efficiently as the…

No problem @kacy . To help the community, can you post a screenshot of what you did in the end in your ETL?

Also ... reframe the question. what do you really want to know the answer to / track? Do you want to track datasets that haven't updated? ETls that haven't run? ... you may not be able to get the specific piece of information you want out of DG / DS, but if you reframe the question, you can probably still get the data you…

Isn't that information available in the DG or DS datasets dataset? (governance or stats)

Only thing I'd add to @GrantSmith is when you do your string correction in Domo, prefix your values with a string, like C or A to prevent any subsequent dataflows or cards from auto typecasting to a different data type. Sounds frustrating, but keep in mind Domo (and all automation / integration oriented solutions) work…

sum(CASE WHEN (CASE when`Temp`>=24 then 'warm' else 'cool' end)='WARM' then 1 else 0 END) / sum(CASE WHEN (CASE when`Temp`>=24 then 'warm' else 'cool' end)='COLD' then 1 ELSE 0 END) ... uh ... no ... it's not adding percentages. it's just telling you that you have more Warm cases than cool cases. i.e. you have 15 cool…

... is there a connector labeled teradata in the connectors area that comes with an FAQ of how to get started? Sorry, that sounds snide, but ... it seems like a quick search in Domo would have solved this problem, so i'm wondering what i'm missing. Do you have a more specific problem? or ... just don't know how to use…

Troubleshooting. 1) Take out aggregation and just pump your results into a table card. 2) break your beast mode into smaller beast modes. what is the result of datediff(current_date() , batchLastRun) ? for each row, is it returning the expected result? with visual inspection, are the values comparable to 2 (i.e. is it…

https://join.slack.com/t/domousergroup/shared_invite/zt-dxq99gyf-MBatRTzIbpUAqTCYfDDJZw I've got some downtime until my next call. If you want to do a team's / zoom, ping me in the Slack group.

@MarkSnodgrass what if you have NO data for any account in August? Do you want to skip the month of August from your percentage calc?

I don't think any permutation of COUNT DISTINCT in beast modes will get you the answer you're looking for. I solve this problem with ETL like this. https://www.youtube.com/watch?v=Xb4QgKYgaqg

Timezone only affects visualizations. Where did you test NOW()? During ingest and transform phases, Domo assumes data is in UTC.

@Steve-DOMOnoob sorry for being dense, what is the math you're trying to do? the pareto takes one axis and one measure... so if you take sum(CASE WHEN WARM ... then 1 else 0 END) / sum(CASE WHEN COLD ... then 1 ELSE 0 END) would that get the desired result?

https://join.slack.com/t/domousergroup/shared_invite/zt-dxq99gyf-MBatRTzIbpUAqTCYfDDJZw Pop into the global slack, for the domo user's group, we have a guy William who is a guru at workbench related stuff.

Chris, You should always do testing before pushing a dataset into production. Don't just make changes on a production data flow... Make a copy of the ETL and try it. But yes, it should be a LEFT JOIN assuming your Date table is on the LEFT. A left join will keep all the rows from the left side and any matches from the…

sorry so late. i hope you figured it out. pretty straight forward. just a multi line chart no aggregation. just like you said create a separate series for each group of hours. in my example i have one hour per day (but i'm lazy so i have a 12 hour day) and then the associated state

not my strong suit here... did you get it resolved? https://dojo.domo.com/t5/Workbench/Workbench-ODBC-Global-Replacement-Variables-Main-use-of-and-how/td-p/45499 https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Connecting_to_ODBC_Data_in_Workbench_5 (section 19) the documentation suggests the syntax…

i'm not sure i followed your question. you described 'file data' is your data originating from Adobe APIs or is it originating from a file? if it's a file ... just use file upload. if it's from an API then use an Domo Connector. If you're writing a custom connector ... you can only access what's available via Adobe's…

... set your lag to n * 7?

task automation. usually you'd use that in the context Domo's writeback connector offering. or at least... that's the dream they sell ? a writeback connector is essentially a tile that runs at the end of magic etl that usually just ... sends data from Domo to another system via API. in your case, instead of just pushing a…

the error message was 'something went wrong'? are you positive the credentials you're using to access salesforce (via domo) have permission to use API access to Salesforce? I wouldn't assume that's a de facto privilege that everyone has.

ooof this was fun little challenge! https://www.youtube.com/watch?v=eifSYZIcPzg the short answer 1) you can't do it 100% as beast modes in Domo (you can get 75% there with window functions but it's not close enough). 2) you should probably do this in magic 2.0 (beta) it'll be super fast if your data isn't streaming and a…

oh ... well that makes it easier i guess. sorry i'm half looking at this at 9PM ? You can do this with a LAG function in a beast mode. Contact your CSM to get windowed functions enabled on your instance. https://www.youtube.com/watch?reload=9&v=cnc6gMKZ9R8

? they can't charge you if you didn't put in a credit card! no you won't get charged.

yikes... this is ... not the ideal way to structure your data ... but we can make it work. Goal: identify the record that = the first day of the month and the last day of the month then caculate the average between the two. If it were me, I would recommend adding these collumns to a date dimension and then joining the date…

? @Microsoft-Dude ? subtle dig in the profile name? If you're a PowerBI guy, I'd love to have a conversation with you sometime, I need to do a YouTube video on "getting started in Domo for PowerBI developers" b/c building datasets in Domo is SO DIFFERENT.

https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Beast-Mode-Sliding-Window-Function-with-Partition/td-p/48407 This thread and associated YouTube video will get you started. Make sure to contact your CSM and ask them to enable windowed functions in beast modes.

@shamal an Admin is an Admin. There is no concept of a departmental admin in Domo ** yet ** but it is a feature they're working on. In the immediate term, you could create a custom role (talk to your CSM) which gives more finite control over grants.

AFAIK ... depending on who you talk to at Domo the answer may flip flop depending on where the stat is collected from. But I believe the correct answer should be Data Fusions DO NOT count. (I say this as a former employee of Domo, but you should check in with your CSM, and make sure they give you an answer in writing ? 

... Domo does have white labeling options ... but it's a for pay conversation. @chrishaleua