jaeW_at_Onyx Coach

IMHO, easiest way to accomplish that would be to build out that logic in scripting and then at the end of the script trigger data transfer into Domo. The JavaCLI would be a handy tool for pushing data to Domo This is the official documentation here…

Yes, you can recreate 'parameterized queries' in Domo with a webform: https://www.youtube.com/watch?v=wmMrnPO9ivY

Domo uses MySQL 5.6+ Type SELECT @@VERSION for the exact version number. This version of MySQL predates the implementation of Windowed functions. You can recreate it using user defined variables. https://stackoverflow.com/questions/3333665/rank-function-in-mysql Without performance tuning in MySQL, you'll probably get…

Make sure your Beast modes for 'Users this week' and 'Users last week' return appropriate values when separated into two separate BMs. Then, make sure you're not Getting NULL b/c you can't add x + NULL (you get NULL).

@imelendez I'm not sure I understand your question. If i had to guess though you're trying to calculate duration. If so,wrap your dates in the UNIX_TIMESTAMP and then take the difference. duration_in_seconds = UNIX_TIMESTAMP(end_dateTime) - UNIX_TIMESTAMP(begin_dateTime) @GrantSmith , I think that's the solution you found…

1) try creating a URL with the URL of the image and make sure it works (it is definitely possible to create a URL, consider adding target ="_BLANK" Once that works, try altering to add the image. If I'm honest, off top I don't know if it'll work. But step one would be to make sure you have the sytnax of your href straight.…

Sorry. AFAIK there is no way to force Domo to fill in blank rows. But think about it. Visualizations only work based on data the know about. Conceptually we know that we're talking about 'hours in a day' of which there are 24, but Charts usually have no built-in logic to understand that UNLESS you use a date based chart…

@GrantSmith wrote:If you have window functions enabled in your instance you could do this via a windowed function in a Beast Mode instead of a running total card: SUM(SUM(1)) OVER (ORDER BY `Date`) And then utilize @MarkSnodgrass 's solution about adding a month to the date for display purposes via another beast mode. If…

Thanks for sharing my solution @GrantSmith , it should work for your use case @user095063 . An alternative you could also consider building an offset into your data by using an offset table with a Fusion. https://www.youtube.com/watch?v=CDKNOmKClms&t=705s In this example the offset is one year, but you could easily modify…

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…