jaeW_at_Onyx Coach

Working with Beast Modes is most similar to creating columns and calculated fields on a table or pivot table respectively with the extra challenge that you cannot use 'cell references' to refer to other rows of data (i.e. previous row) without 'special code'. Beast Modes / SQL are dissimilar to VBA insofar as you can't…

uh... i don't think you've provided enough information for people to give you a good answer. if you're applying date filters at the page level yes, it will filter your cards. So if you have a card that (for example) calculates the percent change between current month and previous month, and then you apply a page filter to…

Step 1. make sure your measure is aggregatable .... so instead of 'Open' / 'Closed' use a 0 or a 1 so we can take the SUM() or AVG() . For your reporting requirement, i think i would be VERY clear about the question I'm asking. are you asking: * "at the start of the week, how many projects were open?" or are you asking *…

Without knowing any more about your depth of knowledge in SQL, it sounds like you may want to brush up on the implications of what a LEFT JOIN does versus an INNER or OUTER join. Recall, a LEFT JOIN will keep all records on the left side and remove any records on the right that don't have a match (on Vendor Id). So in your…

That is interesting and definitely sounds like a bug that you should escalate to support@domo.com They'll have access to logs which will help identify why the behavior is different...

generally if the data does not upload in a recognized format, it implies that there is an issue with the data preventing CAST as date. but to verify. Have you and your colleague (with Windows and Mac) tried uploading the same file on your respective machines using the same method? I would be surprised if it made a…

There is a beta feature in development that will support this. talk to your CSM. I believe it's called filter groups.

I covered this topic a while back. https://www.youtube.com/watch?v=YgevJkjeFqw&t=1s Basically you need to structure your data 'the right way'. It's a bit of a hack but pretty flexible!

@bof this is super valuable feedback that I've seen several times. Please make sure to submit feedback in the Domo product via the rubix cube menu.

@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…