jaeW_at_Onyx Coach

@hamza_123 yeah you can use a custom app to do anything! Ryan O and his team are the folks that build custom apps in Domo, but I can show you how I did a similar thing. In a nutshell, the pieces you'll need: Domo Dev Studio prereqs (ryuu etc.) https://developer.domo.com/docs/dev-studio/dev-studio-overview Then: SQL API to…

I was struggling with this too. But keep in mind the AppDb API and the associated collection ARE NOT necessarily under <yourinstaance.domo.com> If you recall in the documentation for setting up your manifest you have to set up a proxy to where your app is hosted. https://<YourAppId>.domoapps.<yourProdInstance>.domo.com…

your syntax for a case statement is wrong. case when `est_ship_date` < DATE_ADD(CURRENT_DATE()interval 3 days) then ‘next 3 days’ when `est_ship_date` < DATE_ADD(CURRENT_DATE()interval 7 days) then ‘next 7 days’ when `est_ship_date’ < DATE_ADD(CURRENT_DATE()interval 14 days) then ‘next 14 days’ when `est_ship_date` <…

Side note, I do hang out in the Domo User Group Slack channel, https://join.slack.com/t/domousergroup/shared_invite/zt-dxq99gyf-MBatRTzIbpUAqTCYfDDJZw If you have questions about getting stuff done in custom apps, I'm working on building up a network of Domo app developers!

No. that's not at all what i said! Of course you can get it from the Dataset API. https://developer.domo.com/docs/dataset-api-reference/dataset If I needed up to date information like this in Domo, i think i'd try to find a clever way to script the collection of this information for a subset of datasets in a CSV via the…

If you SELECT VERSION() you'll see which version of MySQL you're developing against, MySQL 5.6, https://dev.mysql.com/doc/refman/8.0/en/with.html MySQL 5.6 does not support CTEs :( But if you have a list of Dates (a date dimension) you could accomplish the same thing with a simple JOIN SELECT a.* FROM a Join Date d on…

@FaizulHassan is it fair to assume you've followed the steps outlined in the documentation? https://developer.domo.com/docs/authentication/overview-4

Ooof... this is not a 'beast mode question.' this is a SQL question. and you can literally google "how can i calculate YTD in SQL' and get the answer. I'm not saying that to be snarky. I'm pointing out that Domo is built on technology that is well documented online and you'll find hundreds of resources that will give you…

Same as: https://dojo.domo.com/t5/Card-Building/Percent-Absolute-Change-WoW-as-a-Beast-Mode-Column/m-p/49731

The reason your % Change isn't working is because you have Date / Week on the axis. If you put a Date on the axis, then your beast mode only has access to the data related to THAT date. So it's impossible to know what the value was for the preceding date, b/c it's not accessible. Imagine your data is an excel spreadsheet.…

I guess it depends on what you're storing in AppDb vs. what you're pulling from Domo Vault. AppDB won't naturally support pagination b/c it doesn't Domo hasn't built filtering AppDB API. You'd have to do all the filtering AFTER pulling the data into the app. If you're pulling data from a Vault dataset, you can use the SQL…

Sure, I covered a bunch of Finance tutorials in this series of videos: https://www.youtube.com/watch?v=KwMkv_OqZn0&list=PLUy_qbtzH0S53Kfztj1IniPqaAdaA4iEC&index=5 They should give many tips on how you can systematically approach financial reporting. Beyond that, I'd be happy to make myself available in a consultative /…

There is functionality coming out in Beta called Filter Views (I believe). If you have a connection with Josh M or Chris H, ask them about it. Alternatively, talk to your CSM about getting into the Beta program.

Do you have any details like ... what the calculation is or what the granularity of the data is?

@AndrewMeier , I assume your 'last week' filter is explicitly setting a date range. What if you created a column on your date dimension for isLastWeek. Then if you set the filter 'isLastWeek= True, then as your date dimension updates the filter value is always correct?

Ask your Domo Admin to generate an access token for you.

Not all datasets necessarily have the BatchLastRun Date (which ... admittedly is a bit of an oversight). In the absence of the column, you could pull that data from the DomoGoverance_Dataset dataset and JOIN that data into your dataset. Just be aware that the data in the DG dataset will only be current as of the last time…

@DMJerryVuori , you can adapt the design pattern in this video to get the desired result, https://www.youtube.com/watch?v=CDKNOmKClms

To @GrantSmith 's point '01-01-2019' won't necessarily automatically convert into a DATE when compared to the value on the left. convert_tz(pcd.`person_created_date`, 'utc', 'us/pacific') >= '01-01-2019' I believe '2019-01-01' WILL automatically get converted to a date. Grant is correct, re. the CAST. But to test it, you…

do you have any details?

@Figauro the question isn't whether you're using a LEFT or a RIGHT join. The question is which side of the JOIN has the duplicates? (the many side of the 1:M relationship). You want the M side to be on the right. If you think you already have that, then apply a GROUP BY `SHIP FROM ID` on the LEFT side before the JOIN. This…

It might make sense to break your beast mode into it's composite parts, and then put each metric in a separate beast mode and drop it onto a table card without any other columns on the axis. in order for your summary number to work, you can't have any NULLs because CONCAT( <arg1>, NULL, <Arg2>) will return NULL. Also…

@Nek here's a tutorial video on how to alter your Fusion using the Java CLI. https://www.youtube.com/watch?v=9HYx1vn3HRM In your case you'd want to drop columns under the MAPPING and the COLUMNS clause

You could build a custom app that gives the desired experience... but that would require building a custom app.

https://www.youtube.com/watch?v=wmMrnPO9ivY I've done a tutorial video on this topic here. Good luck!

Make sure you know which Average you want when you use the subtotals. See my screenshot. with AVG() aggregation , you'll get the 'row average'. In my example SUM() / COUNT() = 1.7k on the subtotal. this is 'normal average' or rin my case 'the average transaction amount' But if in your subtotal you're looking for the…

@GrantSmith would it make sense to stack the data Such that you have ACTUAL UNION FORECAST UNION LAST YEAR OFFSET with a column 'Activity Type' to differentiate the three sets of data. Then use a CASE statement to differentiate between SUM(CASE WHEN Date <= today() then Actual ..) and SUM(CASE WHEN Date > today() then…

@crispinvaldez I don't know what to tell you. Email this screenshot to Chuck and ask him to validate that Windowed functions are enabled on your instance of Domo.

aww geeze @crispinvaldez , now i feel like a jerk. I did test out LAG() in my instance of Domo before replying and I did get a result that with 5 seconds of examination looked correct. In general Domo tries to avoid sunsetting features that would impact users, so if someone told me "it worked yesterday but broke today…

@kacy no worrieis. Pare a test function down to just one LAG() function. Make sure that you're including `TimeStamp(use)` in the GROUP BY clause of the SQL function your table generates. The LAG() function must have the same granularity as the number of rows in your final visualization. (so Timestamp, must be on an axis or…