GrantSmith Coach

You're deafaulting to Normal if the Donors is null. You can add an additional clause in your case statement to handle NULL values: case when value < lower_bound or value > upper_bound or value is null then 'Outlier' else 'Normal' end

Summary numbers can accept some simple HTML coding so you can change the font size using HTML.

REGEXP_REPLACE(`field`, '^.* ([^ ]+)$', '$1') * 1 this should find the last value in your string after the last space. Multiplying it by 1 will convert it to a number. Will the numbers be always at the end or anywhere in the string preceded by AUD?

this is because when you’re concatenating everything together it ends up being a string and it loses the formatting. You’ll need to implement your own formatting as part of your beast mode.

Typing on mobile is hard :) removed → recommend.

You can utilize the onFiltersUpdate function within your domo brick to capture the event when the filters are changed.

it’s likely a backend issue where Domo is having issues saving your dataset due to the schema changes. I’d removed logging a ticket with support

If you want to filter on the actual numbers that it needs to be part ofyour dataset. An alternative method for doing period over period is to restructure your data calculate the period over period in a beast mode save it to the dataset and then filter that value. I’ve done a write up how to do this here:

you can change the interaction of the card on your dashboard to drill in place to allow users to drill but keep them on the dashboard. Just edit the dashboard and for each affected card change the interaction from the cards wrench menu to be drill in place

Are you including the user_type parameter that's outlined in the GoHighLevel API Documentation?

There's several functions which aren't listed in the function list but do still exist. Hopefully Domo gets it updated.

CONCAT(SPLIT_PART(`url`, '/', 1), '/', SPLIT_PART(`url`, '/', 2)) SPLIT_PART will get the values with the data split out by a specific character. It's undocumented in the UI but is accessible. Concat then takes those two values and combines them together with the / inbetween

due to how Domo processes data it needs a record for each day of the subscription. Can you get a record for each date and the aggregate the totals in an ETL per day or do you need to filter your data?

Another potential alternative is to convert your dates into unix timestamp (TO_TIMESTAMP) which would be a number, this would then allow you to run a median on the number and then just convert the median back to a date (FROM_UNIXTIME)

You can have a bit more flexibility if you restructure your data using a date dimension table with custom offsets so you can then filter on any time frame and get the 12 months ago for the exact same timeframe instead of just the current timeframe. I've done some write-ups in the past about how to get this configured and…

Correct, you'd likely want the full page URL to accomplish this.

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.