GrantSmith Coach

I'd try and use some URL encoding for your pfilters value as that's likely what's causing the issues with the quotes not working. You can refer to https://domohelp.domo.com/hc/en-us/articles/360043430113-Sample-Beast-Mode-Calculations-Miscellaneous-Transforms#5. Also you can use a website to do the URL encoding of your…

Hi @ahobson Case statements are evaluated from a top down approach and will only evaluate the first true condition it finds. In your case it'll return 'canada' first as that's the first condition that was met to be true and it won't ever return growth.

When using the file upload you should be able to set the Update Method on the settings as Append so when you upload a new file containing the new rows it should put it at the end of your dataset.

What does your HTML / beastmode code look like?

It doesn't support aliases. The beast mode you're creating is essentially the alias for your calculation

Hi @Kervin Your code should work to pull the value from the COLUMN column. If you're needing to select from a different column name based on certain criteria instead of COLUMN then you could utilize a CASE statement inside your CONCAT:…

We just need to add another match group () to the regular expression and surround the entire IP address to match the entire IP address. CASE WHEN REGEXP_LIKE(`ip_address`, '^.*199\.15\.([0-9]{1,3})\.([0-9]{1,3}).*$') THEN  REGEXP_REPLACE(`ip_address`, '^.*199\.15\.([0-9]{1,3})\.([0-9]{1,3}).*$', '$1') ELSE '' END $1 will…

It is a bit odd why your Rent Last Changed field won't take the substring as it appears correct. Here's a few other options for you to try: Utilize LEFT in a formula tile: LEFT(`dRentLastChanged`, 10) You could try to utilize a formula tile to convert it to a date: DATE(TIMESTAMP(`dRentLastChanged`)) Alternatively you…

Hi @dylang91 First thing I would simplify your beast mode. If you go in descending order of your buckets so that the largest bucket is first you can remove the secondary conditions on each of your cases because the CASE statement will evaluate the first and only first condition where it's true so future conditions are…

@JunkDoom Embed permissions are configured on a dashboard level however multiple users could embed the same dashboard. If you're worried about dashboards being shared publicly or who's embedding them you can revoke that permission in a custom role and make sure your users are set to that role.

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`))