GrantSmith Coach

I've done a writeup of lag functions and rolling averages before utilizing Beast Modes but the idea at the end is the same concept. You just need to calculate the Lag for 1 month ago and 2 months ago into three separate fields. Then add all 3 together (current month, 1 month ago and 2 months ago) and divide the total by 3…

You should mark your connector schedule as manual and save it, then when you get to the minute you're wanting it should update to the minute it's currently at when you save the schedule.

Hi @JR_S1L You'd need to keep your data as is to partition based on name to get the lag for the prior 3 months to get your rolling average. You can use a rank & window tile in Magic ETL to calculate the lag just make sure you're partitioning by the name and that you're sorting/ordering by the month

@yli_2596 There isn't really a simple way to change the hourly schedule to run on a specific minute of the hour. Domo did this to help spread jobs around a bit so they're all not running at the exact same time. You'd have to create the job on the minute you want it to run. Is this a workbench job or a data connector?

Use a JOIN tile instead with an INNER join to join your prod and google datasets together based on your join condition. This will fitler out any records in your prod dataset which don't appear in the google spreadsheet.

Make sure you’re filtering your data after your join so the month of the journal entry transaction is the same as the month of the budget forecast. You could do something like this in a conditional filter: LAST_DAY(`Adaptive Date`) = LAST_DAY(`Netsuite Date`) LAST_DAY is a function that returns the last date in the month…

@NathanDorsch I'd recommend reading an article I wrote up on how you can combine your data to do YoY or MoM more easily and have each of those included in the same graph using separate beast modes.

You’re correct. Administrators are allowed to see all data so you wouldn’t be able to restrict their access. you could set up an alert on the access logs to send an alert if someone other than the approved users accessed the card but they’d still have access to it and the data.

You can use pfilters in the URL to pass filter values. You can read up on them here https://domohelp.domo.com/hc/en-us/articles/360042933114-Using-Pfilters-to-Apply-Filters-from-URL-Query-Parameters-to-Embedded-Dashboards

@NathanDorsch That's quite a lot of cards on a single dashboard which typically makes it hard to tell a data story with that many. I'd recommend breaking them out into separate dashboards. Other things you can look into would be The number of beast modes stored on the dataset used or not as they're all processed when the…

I'd recommend logging a ticket with support and raising the issue with them so they have better visibility into the frustration it's causing to help encourage them to see if they can fix it in the future.

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…