jaeW_at_Onyx Coach

@hamza_123 in Domo it's called a 'Trellis Chart' new ... sometime last year i believe.

"We are considering an app so that we can display additional input fields used to re-calculate the data table and/or save the additional information." ... it's unclear what you're trying to accomplish. You can use pfilters in URL strings to filter cards:…

@Simon_King I get that it looks like you're battling with authentication. It's unclear to me where you want to apply this code. We have an IDE to facilitate connector development that simplifies authentication. And similarly, if you're passing data to APIs inside a custom app, there's tooling in Domo java CLI that supports…

@RDSco , You can accomplish this Period calculation using parameterized queries. Take a look at this video as a foundation. https://www.youtube.com/watch?v=wmMrnPO9ivY&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=2&t=63s You can set a date and then use BEAST MODE + CASE statement to calculate the range of dates for…

If you want to stick with Domo-integrated workflows, ask your CSM about the Form Builder App or any apps for capturing user input. I'm pretty sure there are a handful of free and premium options.

https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Setting_the_Time_Zone_for_a_Workbench_5_Job Take a look at this KB. I'm 90% positive that if you set this value to UTC AND you ingest the data into Domo, it will store in UTC and DISPLAY according to company settings. TO TEST THIS Upload Date,…

Awesome, please mark solution answers if appropriate! Glad to help!

I suppose you could make a test account that is an Admin and just carefully control access to credentials. For a multi-tenant environment, Domo Publish might be the best / most secure solution that mitigates risk of data leak. In the absence of that option, check with your CSM about Custom Roles. There is a grant…

https://youtu.be/-yJXArKUNFo @swagner here you go!

PDP was not designed as an alternative to Filtering... i think organizations get themselves into trouble when they start mixing up the two. Take a look at building Beast Modes or using Webforms fusioned to datasets where you define custom groups to create custom groupings... but i strongly recommend against trying to use…

Part of the issue can be related to caching. When you query a dataset in adrenaline, Domo starts caching some of the results. In my mind, i think of it as analagous to the Statistic tables you build in a SQL database or the cache you have in MS SSAS MultiDimensional. So, the more questions you ask the faster Domo gets at…

Is this a Domo connector or one that you wrote? I'm surprised that Domo didn't auto_adjust the duplicate column name OR fail the ingest. If it's a connector you wrote, consider reshaping the data to have more rows and fewer columns. That's going to be a real pain to build analysis against. If i had to guess you've got…

@GrantSmith , Just do the JOIN on a small handful of columns, start with 2 columns from the LEFT and the RIGHT side. Keep in mind SELECT * across two deep tables can be ugly ... especially if you have wide tables. Validate that you get the expected number of rows (14.7M) in the output. It's wild to me to have 14M…

@MarkSnodgrass is defo right to check the datatypes assigned in the Schema. Keep in mind that in your SELECT statement if you divide an INT by another INT (integer) it can also truncate decimals, so make sure you're following the rules of how SQL works and assign an appropriate datatype. Also, the Domo UI can be a little…

In Magic: create a copy of the column converted to TEXT and do a REGEX / STRING transform. In MySQL: use date_part functions (like hour). Best Solution: split date and time (HH:mm) into separate columns during data ingestion. THEN use a Fusion to join a Time Dimension table (where you have one row for every minute of the…

@texas , @GrantSmith nailed the answer on the head. Only thing you'd want to do is fill cases where the START or END date are NULL. (usually for EndDate I'll set it equal to today). If you don't, you'll eliminate all open projects.

Ben Schein covered this during a Demo at the most recent Domo EMEA User Group meeting (see the recording in the linked post). https://dojo.domo.com/t5/EMEA/The-next-DOMO-EMEA-User-Group-Meeting-is-16-4-2020-at-1430-UTC/m-p/47849#M1 the Data Explorer views beta will make it possible to export datasets with 'beast modes' as…

@SeanPT is correct. As i understand it, unless specified otherwise, Domo will ingest your data and assume it is in the timezone of your company settings. From there it will store the data in the data layer in UTC. The Visualizations will use company settings to display 'the correct timezone.' If being able to display…

take a look at the list-report command in the Java CLI , does that get you started?

@user073741 , i would start by paring back my stored proc to ensure that i had the proper syntax for CREATE-ing and calling a stored proc. keep in mind we're on mysql v 5.6 i believe. THEN i would take a really close look at the error message. it says <number> FROM. I would guess that you have values in your table that…

concat( '<a href="mailto:' , case when rand()> .5 then 'someone@example.com' else 'hello@example.com' end ,'?Subject=Hello%20again" target="_BLANK">Send Mail</a>' ) both of these work fine. are you certain your fields don't contain blanks? CONCAT( '<a href="mailto:', (Case When Length('jae@domo.com') = 0 Then…

not the answer you want but definitely should open a support ticket. Check and make sure you have ownership of all the cards? i'm not gonna lie... no idea.

AJ, "A column in this calculation does not exist" says it all. there's a column that doesn't exist. if i had to guess your CONCAT is not concatting the way you expect it to, probably a mix up between " , ' and `. build your concat statement without the case, and slowly add pieces of the HTML / concat statement until you…

No, unfortunately Domo cannot be run on local infrastructure. you can use federated query to keep all your data on premise, but that's as close as it gets.

CASE statement? Case when sum(amount) <=0 then 0 else sum(amount) end

@Simon_King i assume you're trying to create a custom connector? https://developer.domo.com/docs/custom-connectors/connector-dev-studio takes a hot minute to get into the tutorial section, but i wrote an article to build a spotify connector from scratch:…

@WizardOz check in with your CSM. It should be available.

Fair enough, if you must use Python do it. If it were me, i would have an ETL where i do the 'easy transformations' in magic, and then a second ETL where i change the granularity of the data to one row per day. WHY? 1) changing granularity is probably a requirement specific to a dashboard requirement. Whereas, a cleaned-up…

'Filtering on aggregates' is a Feature switch that can be enabled by your CSM. It comes with the caveat that it is a beta feature that hasn't been fully developed and integrated into analyzer so some functionality around exports etc. won't work. Because of the caveats, I personally don't use it often and instead try to…

SQL TO THE RESCUE. Use a JOIN on BETWEEN. SELECT t.* dd.date FROM date_dim dd JOIN transactions t ON dd.date betweent t.startDate and t.endDate EDIT:: can't remember if mySQL supports BETWEEN SELECT t.* dd.date FROM date_dim dd JOIN transactions t ON dd.date >= t.startDate and dd.date < t.endDate