jaeW_at_Onyx Coach

.. it's not that Preview isn't showing your preview accurately, it shows a max of 100 rows by design. That's just ... how it works. What you can do is FILTER some of your data before you get to the APPEND tile. If you know you're interested in a specific date, customer, or amount, apply the filter and then look. Also, an…

I would bet a year's salary that the problem is in your JOIN clause. There are two possibilities, 1) you're JOINING on a column that sometimes contains NULL. You should never JOIN on a NULL because it creates a cartesian product. in other words, you ultimately multiple each row on both sides of the JOIN by any row that…

@PhilD instead of JOINING the aggregated values to your transactional data, make your dataset TALLER instead of wider. Create a section of data where ActivityType = Actual. Then UNION your aggregation where ActivityType = GroupByResponseGroup (or whatever your appropriate group by clause is). In your beast mode use --…

If you have Magic 1.0 you split your data into 2 parts. Where where Col B is NULL and Col B IS NOT NULL (use FILTER tiles) then you can use SET COLUMN tile or I use SELECT and just choose the column I want to keep. If you're on the Magic 2.0 beta you can use a Formula tile and use IFNULL as Mark recommended. In MySQL you…

Also if you have Magic 2.0 (beta, talk to your CSM) you can use INSTR() in the Formula tile.

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