GrantSmith Coach

Domo Workbench is attempting to process everything in an American way. To get around the date issue you can utilize a Custom Date Format Transform on your data where you can specify the specific date format for Domo to interpret your data.…

No, there isn't much documentation around the export-data command on the knowledge base. You can get help on the command to tell you what parameters it expects when running the command: > help export-data export-data: Exports DataSet to a CSV file export-data -i <dataset_id> -f <file_name> usage: -f,--filename <FILE>…

You can't send a text directly from Workbench however there may be a few different workarounds. Major carriers in the US may offer the ability to email a specific email address to then send a text message. This article may be helpful: https://www.techwalla.com/articles/how-to-convert-email-to-a-phone-text-message…

You can utilize MagicETL and a JOIN tile with a left join. The left dataset should be your master schedule and your right table should be the Secondary schedule. Then you can use a filter tile to filter for blank values in the secondary schedule's URN value. This will show all records in the Master Schedule which aren't in…

You can do something like this to handle NULL / empty values: CASE WHEN `Planning Condition Status` IS NULL THEN 'Blank' ELSE 'Not Blank' END

Hi @Steve-DOMOnoob currently the only supported method is to do a recursive dataflow. You can read up on how to do them here: https://domohelp.domo.com/hc/en-us/articles/360057087393-Creating-a-Recursive-Snapshot-DataFlow-in-the-New-Magic-ETL You can also talk with your CSM if there are any other options for you to opt into

@chrishaleua may be able to speak more to this but I believe it's left in there to know that it was embedded at some point and for reference of old embedded links. If it's turned off you lose the record that if there are questions on the embed link in the future.

This is the embed server that handles embedding. It's a bit confusing with the domain being public but all the logic is handled there for private and public embedding. @ChrisBaker@chrishaleua may be able to shed some more light on this.

Since you're doing a windowing function have you looked into the Rank & Window tile?

Hi @Sara321 You can't aggregate an aggregate. You'd need to use a dataflow to pre-aggregate your data to calculate your max month. The downside to this is that it's not affected by any filtering taking place on your card.

This is the intended functionality with workbench when you import jobs from a JSON definition. It creates a new job definition (I'd disagree that this should be the default behavior and should instead ask if you want a new job created). If you're migrating a server you can do some registry hacking to make it think the new…

Currently no, there isn't a way to define spacing between the bars in a grouped bar chart.

This is an issue on Domo's backend. You'd need to reach out to Domo Support and log a ticket with them to have them look into the issue.

I'd recommend logging a ticket with Domo support as it sounds like a bug in the system.

Are these users within Domo already that you'd be able to use their profile pictures?

You can also try and right click on the application and select open to possibly bypass the message or opt down option and double click it to allow for you to open it

Start with you CSM to see if they can assist in getting the latest version.

Have you looked at the "DDX SQL Input Bar Chart Output" DDX brick in the app store? You'd need to specify the different datasets in your DDX brick but you should then be able to utilize your join.

Typically I'll add a text card atop the page and have it simply return an error message saying to select a single date if more than one is selected (I'll also make it red text to clearly notify an error to the user). Currently we can't limit the date selector to a single date. CASE WHEN COUNT(DISTINCT `date`) <> 1 THEN…

How is your data formatted? Is it summarized on the reporting date or are each date a snapshot of the values? I'd recommend using a MagicETL dataflow to calculate the maximum data for each year (calculate the year with a formula tile YEAR(`date`) then pass it into a group by grouping on the year and select the max date…

Does everyone have access to every report or are they restricted on what they can view? Can you utilize PDP to allow certain users access to the different reports? This would filter the data before it's sent to the visualization.

@ozarkram Is your date always in the format of MM/DD/YY? The following regular expression will handle MM/DD/YY and MM/DD/YYYY formats. I'd recommend doing this in a Magic ETL as it'll reduce the processing needed when displaying your data and not have to calculate it every time you load your cards. You can use a formula…

Why do you want to create 1000 versions of the same page? Are you wanting to limit access to the different pages depending on specific criteria? If that's the case I'd recommend a single card but utilize PDP to limit the rows the user has access too instead of creating a bunch of pages and cards that you'd need to maintain.

Hi @lawiti I'll typically add in a timestamp on the queries that I'm writing or add the current timestamp in the ETL I use to process the data and then use that field to display when the data was last updated. A newer option that was just release in the latest version is Smart Text to display the last updated timestamp…

Correct. It can get quite large so if you're not needing specific periods for comparison with your dataset you can filter them out before you join your data.

COALESCE(`rate`, 0) Coalesce also works. It returns the first non-null value supplied. This is assuming your data is actually NULL and not an empty string. If it is you can force it to be null: COALESCE(NULLIF(TRIM(`rate`), ''), 0) TRIM to strip whitespaces at the beginning and end of the string for good measure. Also to…

Are you referencing Adrenaline Data Flows or just Adrenaline in general as used by Beast Modes and DataSet views?

Domo aggregates your data based on the groupings you're using in your card. So in your example if you're doing it at a Zip code level it would have 5/10 (50%) and 400/100 (40%) If you remove the zip code field and replace it with the county it would pull all the values that match that criteria / buckets you've defined so…

How are you wanting QA_TimeStarted and QA_TimeCompleted and CA_DateAccess handled? Most recent time? Drop them? It sounds like you just want to us a Group By tile on the UE_OrgUnitID, OU_MasterCourses_CourseName, OU_CounselsA fields and take the MAX of the DP_DatePosted field.

@MarkSnodgrass - Clever hack!