jaeW_at_Onyx Coach

The Domo DataViews just went into beta, this would be the best/easiest way to create a VIEW of the data that renames columns without having to run it into an ETL. talk to your CSM if you're not already part of the beta program.

If you like the idea of grouping data into bands ... why don't you just group the data into bands? case when sum amount < 100 then .. when sum(amount) < 200 then ... when sum(amount) < 1000 then .. else ... end

Kev, Here's the official Domo KB. https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow Start with that. The notes I've added guarantee that you always get 'the right row' but their implementation is probably good enough, and certainly will get you started. If you and…

you need a table with a list of numbers or a table with a list of dates (a date dimension would be easier) Then you can... SELECT f.* FROM Transaction t JOIN Date d ON d.date BETWEEN t.StartDate and t.EndDate If you only want months then do a subquery JOIN (SELECT DISTINCT lastday(date) as date FROM date GROUP BY…

@KJRowe6 this is a super common question in the Dojo! https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Append-only-missing-rows/td-p/49014 Have a look at this post. Basically you need a recursive query paired with a window function to identify and remove duplicates in Magic!

Why do you need Count Distinct? To categorize your performance you could write CASE WHEN `stats_first_resp_time_in_secs` <= 900 then 'Under SLA' else 'Over SLA' END then take Ticket out of the access and do a row count as your aggregate function. That should answer how many you had under and over SLA.

https://www.youtube.com/watch?v=9HYx1vn3HRM It's a little bit of work, but you can alter the schema of your Fusion using the JavaCLI. Here's a link to a tutorial where i rename a column but you can also change the data type.

https://www.youtube.com/watch?v=CDKNOmKClms Here you go @user054650 . If you have further questions, check out some of the videos on my channel! If you're looking for one on one support, I am available at a reasonable rate to provide consulting services, reach out to me at jae@onyxreporting.com. BTW @GrantSmith , in your…

Oof... it may then make sense to direct your question to support@domo.com there is an old dojo thread https://dojo.domo.com/t5/Data-Sources-and-Connectors/MongoDB-non-SSL-connection/td-p/8239 that mentions having to use SSL to create your connection. Also they suggest pushing the data via Workbench.

Hey @Whimzyy , I recommend you try to put your report together in table builder first b/c this might require some experimentation. given that you're trying to do count(distinct) things can get hairy, but i think you can get your number using a lag function. check out this tutorial.…

@Joe_M , it sounds like you'll need a window'ed function to build out the metric you're looking for. You may have to check with your CSM to get 'window functions enabled in beastmodes' before you can build it all out. This tutorial can work as a foundation! Good luck!…

In stock Domo, AFAIK it's not possible to add layers in addition to the base Lat / Long chart type. You can create your own custom visualizations as SVGs, but then instead of mapping a lat / long, you have to code lat/long to correspond to a named polygon in the SVG…

https://knowledge.domo.com/Administer/Controlling_Access_in_Domo/Managing_Custom_Roles It does look like the ability to Export is a custom grant. That said, export isn't granted on a dataset level it's granted at the platform level. So unless I'm misunderstanding how Custom Grants are set up, either you can export ANY data…

@user046353 1) does the CSV open properly in Excel? 2) if you took the export from Domo and re-imported it into Domo using a CSV connector, does it interpret the data properly? If yes to both, then I imagine Domo / Support would say,"the data is parseable by standard tools," leaving the responsibility to you to reformat…

@MartinB pretty confident that functionality isn't in the product yet. Best bet would be to create a subpage and move the cards there.

Given that your error message suggests a credentials error, I would try using any other IDE to connect to your mongDB, maybe VS Code or a local SQL management tool that you know has worked historically. Once you've confirmed that credentials are not part of the problem, maybe try connecting with any sort of VPN disabled. 

if possible, i would recommend against intentionally rounding metrics in ETL, keep the data as raw/accurate as possible. Also, try downloading a sample of your data, the UI sometimes hides the precision of the data.

can you concat / process the data as you push it into Domo? I.e. apply the MD5 processing during ingestion instead of trying to display in Analyzer / in ETL?

What would you use it for?

I'm sure this doesn't help... but the recommended method for commenting on a dashboard would be to use the buzz channel that gets created with each dashboard. would that work in the immediate term?

It'd probably be easier to just have a new access token created. It seems reasonable to assume that .... your access token can not access the things that aren't showing up. To confirm, try the same reports with an access token that has admin privileges. I'd argue, there isn't a good reason to create governance datasets…

Workbench relies on several services to function https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/04Starting%2C_Stopping%2C_and_Restarting_the_Workbench_5_Service Try Start > Domo > Workbench Monitor.

@MarkSnodgrass and @user08570 , the new Beast Mode Manager beta has a feature that allows you to bulk copy Beast Modes from one dataset to another. If you don't have the BMM, talk to your CSM to get added to the Beta program.

@eriena two things to check. 1) the governance reports are only accurate up to the time they were executed. Was the page created AFTER the last time the connector was run? 2) if you're pulling 'Page and Card' then it should capture the cards SHARED to a page. if a page has no cards on it, then it makes sense that it…

In the official Domo literature and training they'd recommend you use a 'Remove duplicates' tile and build a recursive dataflow. https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow Problem with 'remove duplicates' is there's implicit randomness to how 'duplicates' are…

As i understand it the iframes in Domo apps are all sandboxed as a security feature, hence why this would stop working (see linked article). I don't know of a workaround, this might be a question to direct at the apps team via support.…

https://www.webretailer.com/b/amazon-vendor-edi/ It looks like Amazon Vendor Central functions completely ... different from most other connectors. AVC uses an EDI exchange whereas most connectors use an API for data exchange. From the little bit of research i did, it looks like there are third party integrators that will…

Which ETL method are you using (redshift, magic, MySQL)? https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/DataFlow_and_DataFusion_Troubleshooting_and_FAQ Base MySQL does have column and row width limits. If you have one or two absurdly wide columns, try excluding them from your ETL. Does it make a difference? If…

if you're comfortable writing javascript, have a look at developer.domo.com specifically: https://developer.domo.com/docs/custom-connectors/connector-dev-studio, this might be a more ... satisfying experience. without a sample of data or screenshots ... i don't really understand what you're asking.

can you link some sample code here?