Best Of
Re: SyntaxError: Invalid JSON when using the DOMO Governance Datasets Connector
You'll want to put in the name of your instance and not your website.
Enter your customer name. Your customer name is the part in the URL that before .domo.com. Ex: If your Domo instance is located at https://some-customer.domo.com, then your customer name is some-customer.
September 2022 User Group Recordings
Rewatch the presentations from the September In-person user group in Utah. If you'd like access to public data files, see this post on how to join the Dojo Domo instance. To view presentation from past user groups, bookmark THIS PLAYLIST on YouTube.
Ashleigh Stevenson, Business Intelligence Developer at CAE Defense: Course Builder & Google Analytics
Andrea Henderson, Data Pipeline Architect at Domo: Partitioning
Michelle Hamad, Business Analyst at RWI Logistics: Proximity Matching
Huge thank you to our amazing speakers for this event!
Re: Variables Smart Text - Chart axis + legends
@user00344 that is a great idea to be able to set the default value with a function. Current_Date or Last 30 Days. Or you could even get creative with some case statements...
@jaeW_at_Onyx Here is a quick and dirty video describing what I tried to explain in my post. In short, you had the right idea. Hopefully this clarifies things a bit.
Re: Variables Smart Text - Chart axis + legends
Big Time Need for Date Variables:
Set the default to MYSQL functions like Current_Date. I would guess that 80% of users would prefer this to be the default for a date variable.
Re: Disable Auto-refresh
@jennakmeier Cards refresh based on the scheduled settings of the underlying dataset. Can you schedule the datasets to run less frequently or during times when they are less likely to be reviewing it?
Re: Building a filter/fxn for ETL to pick the earlier of two dates when applicable?
You can use the LEAST function to select the smallest value of dates
LEAST(`Observation Date`, `Admit Date`)
If the observation date is null then you'll want to default it to the admit date via a COALESCE or IFNULL:
LEAST(COALESCE(`Observation Date`, `Admit Date`), `Admit Date`)