GrantSmith Coach

You'd need to do a replacement variable and tell it to ignore the rest of the string Try changing your regex to: ^.*\b(AR-\d{5})\b.*$ Then in your replace term use $1 to replace it with your first match group.

Yes, Domo Brand Kit includes custom color pallets the user can define and have included within analyzer for selection.

@jimsteph What happens if you use a table chart and then create separate beast modes for A, B and C to sum them all together and validate those sums are calculating correctly? Do you get the numbers you're expecting for each of those? SUM(A) / (SUM(A) + SUM(B) - SUM(C)) should work according to your logic but without…

I'd verify you're connected to the correct instance and have been authenticated properly. If that still doesn't work I'd recommend reinstalling the plug in and restarting Powerpoint.

If you're wanting to avoid indexing using the Java CLI upload-snowflake command you can pass in the -x flag to ignore indexing. > help upload-snowflake upload-snowflake: The “upload-snowflake” command creates a JDBC connection with a Snowflake database, pulls data in accordance with command options provided by the user,…

The UKG API documentation may be of use to help decipher what's needed and where to get it:

You'd need to specify the subfolder in the relative path parameter when configuring your connector.

Are you passing in the Accept header to tell it what type of content you're willing to accept? I'm assuming you're wanting CSV so passing in "text/csv" as your Accept value would be what you want.

You can create a direct link to a card based on the card ID and a url like the following: https://[DOMO_DOMAIN].domo.com/kpis/details/[CARD_ID]

Appends in ETLs aren't publicly available currently. You can use a recursive dataflow to do an append. Here's some more information on recursive dataflows: Alternatively if you don't care about de-duping data and only want to take snapshots at a specific time interval you can also utilize the DataSet Copy connector and set…

Hi @swagner You're correct in that they're not available in Beast Mode Manager and the two DomoStats datasets don't give you additional information about the variables other than the name and where it's being used. It doesn't have the actual values defined for each variable. I'd recommend adding an enhancement request to…

Per the KB article (: What happens to data when promoting content with Sandbox? Sandbox moves content, not data. The best practice is to keep the data in the production instance and make it available in the development instance using either Virtual DataSets or the DataSet Copy Connector. Because the beast mode is stored on…

You can use two single quotes together to escape it and have it treated as a single quote in your string when `Prescribing Facility` = 'BISCAYNE MEN''S WELLNESS CENTER' …

It depends on what type of processing your python tile is doing. Does it require all of the datasets to be input into the tile to process the data together or can the data be processed independently of the different datasets?

Have you tried sorting based on sales in your graph and then setting the row limit (under filter and sort) to be N?

It depends on the structure of your data and if you're able to process the data in parallel or not. Can you do it in subsections or have the different steps happen at the same time so you can utilize multiple python code tiles? Is the logic you're using in Python able to be translated back into Magic ETL with the tiles?…

Are you authenticating as a user with admin permissions? Have you tried unselecting all of the object in the list saving, and then reselecting them again? Were any Facebook objects removed recently?

Is it Just that one dashboard or can you create another new blank dashboard and test with that embed id to see if you run into the same error? Have you tried disabling the embed for that page and then enabling it again?

This post I've written in the past may be beneficial for your reference on formatting different date differences with the number of days:

You can use a Multi-Value Columns chart with two beast modes, one for -3 days and one for -4 days and use the last 4 days in your date range selection. You can use the -3 days beast mode as your gauge value and -4 days as your comparison value.

Congrats on the MVP @colemenwilson !

One caveat to not about the DomoStats or Domo Governance datasets is they typically only allow for running once a day which can cause real-time reporting to be difficult and inaccurate. For example if a connector is running a minute before your DomoStats data is pulled it will look like it's running for an entire day until…

@Manasi_Panov You're wanting to do an aggregation of an aggregation (SUM [step1] of MAX [step3]) which isn't possible within a beast mode. You can only do one level of aggregation. You'd need to pre-aggregate your data in an ETL before attempting to do an aggregate within a beast mode.

When you created your client id and secret for Domo (@ developer.domo.com) Did you select the dataset scope? Does the user you logged into the developer.domo.com to create the ID and secret have permissions to create datasets or read datasets?

Alternatively here's a beast mode version: CASE WHEN MONTH(`dt`) IN (3,6,9,12) AND DAYOFWEEK(LAST_DAY(`dt`)) < 4 AND `dt` = LAST_DAY(`dt`) - INTERVAL (DAYOFWEEK(LAST_DAY(`dt`)) + 3) DAY THEN 'Exclude' WHEN MONTH(`dt`) IN (3,6,9,12) AND DAYOFWEEK(LAST_DAY(`dt`)) >= 4 AND `dt` = LAST_DAY(`dt`) - INTERVAL…

You can't use a variable directly in the items section. You need to use a variable in the beast mode. You can add the variable control to the page and and configure it to be a dropdown to help apply to your different cards which use the varaible.

You'll likely need to reach out to Domo Support as it sounds like some back end wires are crossed with your ETL.

@JasonAltenburg That's how variables are configured to work. With your case here I think your best option is to stack your data in a dataset with different types of metrics / filters with the values to filter on and then have two filter cards, one for the metric type and one for the values. I know this will increase the…

You can use a beast mode for this SUM(`Revenue`) / SUM(`Days`) You can use the same aggregation and logic for the revenue and days

You'd need to write a script in something like Python to query all your datasets and then update the name / descriptions. There isn't an easy way within the UI. You can use the pydomo package to do this.