jaeW_at_Onyx Coach

Let’s work together in Slack! It’s a faster, simpler way to talk business, share files and get work done. Join here: https://join.slack.com/t/domousergroup/shared_invite/zt-n22nno2s-erzBJFTX3TdYOM_jb4058Q @DataSquirrel Domo spins up a VM (or similar) to process MySQL etls. They've known they're behind for YEARS. I do not…

@Gor_Gonzalez , chose a file, then update the configuration manually.

if the dates are always at the end, instead of using a SPLIT, calculate from the back (using RIGHT and SUBSTRING) Alternatively, if you're confident the dates are always the last value, the use COALESCE() starting from the last column coalesce(`flight date 1`, `global, client`, `product program`) recall, coalesce will…

@user06979 this is the kind of thing you have to do in ETL or a Dataset View. You cannot complete this requirement in analyzer. The gut check response might be to use a window function, but you can't filter on aggregates without a beta feature switch AND with recent changes to Domo, even that won't work. You could…

@PWeed domo has customers successfully using Azure AD. To your second question, when you resync your AD groups are you saying that it's not synccing? I would imagine the sync command should create and remove groups in Domo to match AD. SSO is a bit of a niche area, i recommend you liase with support@domo.com for fastest…

@HowDoIDomo , consider using a Bullet Chart if you don't want an actual line overlayed on a bar chart There is a Period Over Period chart type to allow you to compare to the previous year of data. I would be wary of the Regression b/c as soon as people start adding filters the results get misinterpreted (b/c it's limited…

@serendipity , technically, @GrantSmith and @ST_-Superman-_ are correct, but you do still have options / hacks. 1) build your initial card on a dataset view of aggregated data. apply PDP policies as appropriate. 2) when you create a drill path, you can reference the original dataset, OR point to a completely different…

@user048760 , the short answer is "a card can only be powered by data from ONE dataset". In short, no you cannot create a card that spans two datasets. What @Lady and @GrantSmith are suggesting is that you combine your two datasets into one dataset. Be careful, instinctively, most people will try to JOIN their data…

@gbuckley , Domo does not support parameterization the way you're thinking. You can recreate the metric you're looking for by altering your data model. APPEND a copy of your data to the dataset, and in the second set, replace Fruit w/ "All-Fruits", then your users can filter on "Apple" OR "All-Fruits" and with that slice…

@user082291 , convert your card into a table card and confirm that it still retrieves values. Also, are you confident that your EndDate and StartDate never contain nulls? If it does contain nulls, can you confirm that the math still works as desired. ROUND(AVG(DATEDIFF(`Investigation End Date`,`Investigation Start…

@user15776 , it is possible to have an environment spun up in MagicETL with additional packages included. You would have to coordinate with Domo Support and your CSM. Also, if you have the option, try to go with Jupyter Notebook Integration (or get it added as a trial) you can use pip install to install your own packages…

@andres it's kind of a binary thing right. Either you drill OR you filter. So if you want filtering, maybe make a second visualization / card that handles state-based filtering. This could be a Bar Chart or a Checkbox, Radio box etc.

lag(sum(case when `control or target` = 'target' then `vol_usd` else 0 end)) over (partition by year(`trade_date`)*100 + month(`trade_date`)) I think Domo broke / changed functionality. You can no longer use an expression in the partition or order by clause -- year(`trade_date`)*100 + month(`trade_date`) add this to your…

@MikeRoberts and @GrantSmith it makes sense that rand() would be consistent in Analyzer. you're sending a query to a database that was designed to process multiple billions of rows of data at a time. can you imagine if you asked the query to process each row and generate a new rand() value? oof. what you might consider…

@user09644 , @GrantSmith is correct, Jupyter Notebooks cannot be integrated into an automated pipeline by design. The tool for pipeline automation would be the MagicETL scripting tiles! https://www.youtube.com/watch?v=lhj9zcwai98

@leonardschlemm , pretty sure that's what the IPs @MarkSnodgrass linked are giving you...

Instead of JOIN'ing the data as @Mark proposes, I would APPEND the data to itself. Then replace the "TruckID" value with "Truck_Total" this way your dataset will still respond to filters and you don't have to do weird math. sum(case when truck_id <> 'truck_total' then amount end) / sum(case when truck_id = 'truck_total'…

@Gor_Gonzalez , you can set workbench to use wild cards (*) for the file name. so you could do my_file*.xlsx

@user013818 i'm still not sure i understand your use case... but it sounds like, you need to generate a dataset that for each id, you identify all the possible values for each of the four variables and then one-hot-encode them into a matrix, like the example below, only except just having one column (color) you can have…

@swagner if that information is not included in DomoStats_ActivityLog, I think that would be a feature request / product feedback. EDIT:: OOOOOH except i think either DomoStats_Person or DomoGov has the user profile URL... so if you're taking a recursive snapshot each day, you can tell if the value changed from yesterday.

@user006645 ((sum(`Promoter Count`) - sum(`Detractor Count`)) / sum(`NPS Count`))*100 @GrantSmith is correct it looks like you ARE aggregating across columns. i.e. "first calculate sum of promoter count and sum of detractor count and then subtract them etc. So your syntax looks good. To troubleshoot break each aggregate…

@leonardschlemm , what @swagner gave you is called a window function. this is a common implementation in SQL which can be googled! assuming you have cashiers on the axis, you should be getting that cashiers sales as a percent of total sales. if you want that cashiers sales as a percent of store sales or some other subtotal…

@lwang , all these options are ... ok, but if it were me and i HAD to have an alert, i would use a recursive query to construct a dataset that captures my alert conditions. so whatever your 'system health' stat is, generate one row per day of the stat, or generate a dataset of the conditions that triggered the alert then…

SUM((`PAYMNT_DUE_DT`-`INVOICE_DT`)*`RECPT_AMT_USD`)/ SUM(`RECPT_AMT_USD`) I don't believe your problem is the existence of zeros. Or att least, perhaps not the way you're explainig it anyway. 1) i assume payment_due_dt is a dateTime column. If so, you shouldn't do dt-dt, I'm not sure it's reasonable to assume that Domo…

+1 to @MarkSnodgrass It is tempting for SQL developers to want to use MySQL and Redshift (and fair enough Magic may not seem intuitive), but it keeps the SQL developers as the bottleneck both in performance and distribution of workload (they become the only people who can implement changes on dataflows) -- job security,…

@user013818 , DO/WHILE loops are EXTREMELY inefficient in SQL (and therefore at best we'll call it an Anti-Pattern). Window functions will approximate DO/WHILE behavior. Can you be more specific about what you're trying to accomplish?

Don't JOIN Budget to Actuals. APPEND Budget to Actuals. By Appending you'll avoid duplication and can avoid 'crazy math'. https://www.youtube.com/watch?v=PVbOeLSae9o&t=18s

@DataSquirrel domo datasets are CSVs stored in a data lake environment similar to S3. "I'm a bit surprised to hear that what I'm asking isn't a straightforward question, but, actually, maybe that makes sense. Architecture <> Mechanics." There are books on building performant data models in powerbi. I recommend having…

If you're looking at Data Distribution (especially as a monetized service) Domo does have a suite of tools under the umbrella "Domo Everywhere" The video below is a take on a specific product "Domo Publish" which is possibly a lot more than you're looking for. If you just want to send your customers data 'drawn from domo…

Domo has always had a database layer called Adrenaline (it's what the cards in analyzer are built against)... they just ... don't always document their stack in a way where tech nerds can know what stuff is called :P Magic 2.0 is a MASSIVE improvement over the previous version in terms of performance and speed to create…