jaeW_at_Onyx Coach

If you have a google, Instr() will be an easy MySQL equivalent. https://www.w3resource.com/mysql/string-functions/mysql-instr-function.php

... what dataset are you building your card against? ideally you'll want to use the DomoGovernance Datasets dataset, and then plumb that into a recursive query or configure it to Accumulate data (APPEND). how do you define 'delta' ? percent change in rows from yesterday? if yes, then this will work.

you can simplify this code. if i'm reading it correctly, the goal is to generate one row for each employee during the dates of their employment SELECT ... k.`Status`, d.`Date`, case WHEN d.`Date` = k.`Termination Date` then 'Termination' ELSE 'Active' END as `Status on Date` ### to make this column summable, I would just…

Google LIST_AGG and GROUP_CONCAT. Alternatively look at PIVOT / UNPIVOT in a SQL context. The same thing exists for Magic as Collapse and Uncollapse Columns 

if you're using Domo for real time reporting, you should be on platform 3+. If you asked Domo support or account representative about 15-minute updates, (unless it's explicitly written into your contract) they'll probably tell you you're not paying for that level of service. I hear your point, 'it worked before and now it…

There's a Domo Stats Activity Log quick start.

updating data every 15 minutes... unless you have a proper low latency workflow requirement, it's not recommended. talk to your AE, but 15 minute updates is a non-trivial strain on Domo if you don't do the 'right' workflow. Also, if you have ETL AFTER data ingestion, that's another bit of lag in your dataflow, so if you…

you would want to generate a script file (like a .bat) file that contains one row per command you want to run. ... so i wrote a script that produces the following csv: connect -s 'yourServer' -t 'yourAccessToken' dataset-run-now -i 197200 dataset-run-now -i 197126 dataset-run-now -i 197203 dataset-run-now -i 129139…

how wide are your start and end dates? for the sake of example say you have a row where one row represents project (with a start and end date). If you calculate datediff between start and end date, (let's say 12 days) then you could join to a dataset that is already blown out. So Blow out table would be Join_Col, NUM 1 ,1…

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