GrantSmith Coach

I'd recommend logging a ticket with Domo support to have them look into the connector and see if they know why their connector wouldn't be pulling in the data.

In Google Analytics, a landing page is the first page that a visitor or audience lands on when they visit your website. It can be any page on your site, such as a help page, contact page, home page, or blog post. The landing page is where a user initiates a session on your website. The full page URL is the page that the…

This is a great idea. I'd add it to the Idea Exchange.

One thing I always take into account when designing ETL Pipelines is to be a teapot - short and stout. What I mean is that you can filter the data as soon as you're able to and also selecting only the columns you need. This makes the data short and faster to process as there's less data. On the stout side of the coin,…

You can join the dataset to itself so that the employee's manager field is joined to the employee field then you can rename the second manager field to manager of manager.

If you want just the third character, you can use substring: SUBSTRING(`productnumber`, 3, 1) 3 = starting character number (1-based) 1 = number of characters to extract

It's not supported with that connector. If you need to append data you can feed it into a Magic ETL dataflow and then set the output tile to Append. You can have it trigger on the initial Google sheet update.

Try something like this to make it a bit simpler: REPLACE(REGEXP_REPLACE(SPLIT_PART(SPLIT_PART(``, 'Sent:', 1), 'To: ', 2), '[^<]+<([^>]+>)', '$1'), '>', ',') SPLIT_PART(``, 'Sent:', 1) Gets evertying in your string before 'Sent: ' - drops everything after it SPLIT_PART(SPLIT_PART(``, 'Sent:', 1), 'To: ', 2) Gets the…

Are you wanting the From and To both to be included or just the To? Will the From and To fields only have a single email or would there be multiple emails?

CASE WHEN Prod Art = 'A' THEN 'Artwork' WHEN Prod Source = 'M' THEN 'Sourcing' ELSE 'No' END

It sounds like you're wanting the value difference instead of the percent change. You can update this under Chart properties - Change value options - Value = Value Change

Try converting to a window function so that each row is compared to a single value instead of the aggregated value. CASE WHEN `D's % of AOR` = MAX(`D's % of AOR`) OVER () THEN 1 ELSE 0 END

Domo visualizes data on a row by row basis so if there's no data for a given month it won't show anything. You'd need to restructure your data so that every month has a value. You could utilize the Date dimension dataset, filter to the granularity you need and then left join your dataset to the date dimension dataset. Once…

There isn't an option currently to do this but I'd recommend adding an idea to the idea exchange for this feature.

Currently this isn't an option in the box + whisker plot but I'd recommend adding this to the idea exchange to show bot whisker values.

^ - Start of the text $ - End of the text Combining them together in the rexex above simple enforces that the entire string is made of numbers instead of just finding numbers anywhere in the string

If you're wanting to only find values which are all numbers you can use a regular expression: CASE WHEN REGEP_LIKE(`SERIAL`, '^[0-9]+$') THEN 1 ELSE 0 END If you're wanting to include numeric like characters as well (decimals and dashes) you can use \d instead of [0-9]

Nested bar charts only support showing the overall total. I'd recommend utilizing a Symbol + group bar or a Line + group bar chart and have the average be the symbol or line

Domo can't fill in the dates automatically within the card, your only option is to expand your data set to be on a per hour basis instead of per day.

This is something that Domo has to do as it's a special publish that they do. I'd try reaching out to support and see if this is something they can do for you or log this idea in the idea exchange.

Currently I don't believe this is an option but I'd recommend adding this to the Idea Exchange

You can leverage window functions to do this: SUM(SUM(CASE WHEN `Task Complete` = 'Yes' THEN 1 ELSE 0 END)) OVER (PARTITION BY `Plant`, `Date`) / SUM(SUM(1)) OVER (PARTITION BY `Plant`, `Date`) This will conditionall return 1 or 0 if the task is complete or not and then sum that value up for all tasks for each date and…

I'd recommend logging a ticket with Domo Support to have them investigate their connector as they have access to the actual source code of the connector.

MIN(MIN(CASE WHEN taskEventStatus = 'Completed' OR taskEventStatus = 'CompleteLate' THEN 'Yes' ELSE 'No' END)) OVER (PARTITION BY `PlantID`,`Date`) You can use a window function to return the minimum value (No if any of them are No) for each date and plant ID.

Domo has their AI suite to utilize LLMs in a magic ETL.

you could create your own Date dimension dataset in an ETL and supply your own logic. Then you can ties that y to your datasets to get your custom calendar information

You can try and utilize a window function for your date instead of '04/08/2023': MAX(`OrderHeaderLocalDate`) OVER () - INTERVAL 1 YEAR This will look across your entire dataset and get the maximum date and return it for each row.

Here's a regex version: REGEXP_REPLACE(`field`, '^(.+)\/?', '$1/')

To Edit Domo (DDX) Bricks you need to have the edit cards grant. Participant users don't have this. If you want users to create or edit cards you'd need to potentially create a custom role that mirrors the participant user but also includes the grant to allow them to edit Domo Bricks.

When using date variables we have to define a specific value, it'd be great if it would allow the selection of today as a default as I'm typically wanting to use today's date with the variables. This would also allow me to not have to keep updating the default date as it gets farther away from the current date.