GrantSmith Coach

You rang @MarkSnodgrass ? 😀 @Mikes You're close you just need to tell the regex what groupings you wish to capture with parenthesis. Also I prefer the new formula tile as it tends to work a little bit better. REGEXP_REPLACE(`ip_address`, '^.*199\.15\.([0-9]{1,3})\.([0-9]{1,3}).*$', '$1') For others who may come across this…

I've had some issues where I attempt to stop the service and it'll say it's unable to be stopped but actually stopped the service. Typically I need to reboot the server to fix the issue properly though.

@Golfoholic Have you looked at the list of IP addresses to whitelist here: https://domohelp.domo.com/hc/en-us/articles/360043630093?

You can find my talk on this and other beast modes on demand here: https://domopalooza2022.brandlive.com/home/en/session/4e03890e-9651-11ec-b383-5b1ed051e2ca

Hi @adamxor I just gave a presentation at Domopalooza on beast modes and I discussed this scenario. There's even a write-up here on the Dojo that I did as well: https://dojo.domo.com/discussion/54551/dp22-using-beast-mode-to-build-data-storytelling-adding-business-days

You won't be able to do this within a beast mode as you're needing to aggregate (count number of records in the bucket) on top of an aggregate (counting the number of donations). I'd recommend using a Magic ETL to pre-aggregate your data to group by the donor id and procedure and count the number of donations. Then using…

You can use a custom role to turn off the "Export from Domo" grant and assign the users you wish to not allow data export across all cards and pages to this new role. This is an all or nothing where you can't conditionally apply the export restriction.

You should be able to filter that out in your card on the drill path using the card filter in analyzer.

Try SUM(COUNT(DISTINCT `Account Name`))

Yes, if they're interacting with the app you'd likely need a license. You may also be able to utilize Domo Embed / Domo Everywhere to embed the visualizations within a website which would go based on impressions and not need a Domo license. I'd talk with your CSM about your use case and what the best solution might be.

I'd recommend logging a ticket with support as it sounds like it's a bug. I'd recommend renaming your columns without the period if possible to avoid this scenario as a workaround.

Alternatively if your field may not have a comma but still has spaces surrounding two uppercase letters you can use a regular expression to find and replace your string: REGEXP_REPLACE(`addressfield`, '^.* ([A-Z]{2}) .*$', '$1')

Hi @NathanDorsch Regular expressions are your friend here for parsing this out of your URL string. You'd need different columns but you can do this all in the same Formula tile using different regular expressions: utm_source: REGEXP_REPLACE(`url`, '^.*utm_source=([^&]+).*$', '$1') utm_content: REGEXP_REPLACE(`url`,…

You can use a CASE Statement and DAYOFWEEK to check if it's before Wednesday and then configure and setup your date filters CASE WHEN DAYOFWEEK(CURRENT_DATE()) <=4 THEN offset logic here END

What is the error you’re seeing and what are you expecting to see? It’s hard to diagnose your beast mode without any context.

If you double up the single quotes it'll escape it to a single quote in your string: (CASE when `commitment_comb` like '%Q1 ''22%' then 'Q1 2022' else 'other' end)

Did you get window functions turned on in your instance?

You could utilize a Magic ETL dataflow and utilize the Rank and Window function to calculate the row number based on your partition and then use a formula tile to conditionally set the value of each record. CASE WHEN `Row Number` = 1 THEN 'Unique' ELSE 'Duplicate' END Row Number being the new field you calculated with the…

It depends on how you want to do the comparison. Typically when you look at period over period Domo will just subtract a 1 month interval which would make the 29th, 30th and 31st compare to Feb 28th. There are other options where you'd look at 28 days to keep the days of the week aligned (comparing the same day of the week…

Hi @Vandana You can use some window functions to get the row number SUM(SUM(1)) and then compare that number to 1 since you're wanting the first instance to be unique and all others to be duplicate. You'll need to talk with your CSM to get the window functions in beast modes enabled if you don't already have it. CASE WHEN…

@Hiraayub LAST_DAY(DATE_ADD(`dt`, INTERVAL 1 MONTH))

Hi @leeloo_dallas I may be misunderstanding your request but You can use NOT LIKE in a case statement WHEN `blox_section` LIKE '%lifestyles%' THEN 'LIFESTYLE' AND `blox_section` NOT LIKE '%health%' THEN 'LIFESTYLE' A simpler way would be to put your WHEN clauses in the order you wish for them to evaluate. So if any string…

With LAG you need to know how many records back you'd need to pull in order to properly forward fill that data that's missing. Instead I'd recommend utilizing two rand and window tiles to do a forward fill. Import the Domo Dimensions - Calendar Dataset Within your ETL: Left join you data to this calendar dimensions dataset…

Import the Domo Dimensions - Calendar Dataset Within your ETL: Left join you data to this calendar dimensions dataset Take this output from the join and feed it into a rank and window function COUNT your RPC OVER / Partitioned by the product and ORDER BY Date - This will get us a group number - essentially tells us when…

What specifically are you concerned about having a character limit? To my knowledge the API doesn't restrict anything that it sends back in terms of character limit. Domo will limit data in cells to 1024 characters but that doesn't deal with the API.

Hi @IanMaddrell You can pull in the Beast Mode metadata using the Domo Governance Datasets Connector and select Beast Mode from the report list. It'll have all the beast modes and the formulas used for you to do a filter on.

There currently isn’t a way to do this but I’d recommend adding it as an idea to the idea exchange.

Domo is only going to plot the data you have so you'd need to include those dates. You can utilize the Calendar dataset from the Domo Dimensions connector and left join your dataset to that based on the date as it'll have all the dates for you already. Then you just use the new date field from the dimensions dataset…

Hi @NathanDorsch Do you have specific records with 0 for that day or are those days missing in your dataset? If you have the dates in the dates in the dataset with a 0 value it should appear as 0 and drop down to 0 in your graph.

You might be able to do this with some window functions in a magic etl. You could do a lag function to calculate what the prior row value was. Then use a formula tile to check if it's a Conversion event and then return a value of 1, otherwise 0. Then you can use a Rank and Window tile to do a running total on that new…