GrantSmith Coach

You can use the LAST_DAY function to determine if the current day is part of the same month: CASE WHEN LAST_DAY(CURRENT_DATE()) = LAST_DAY(`Date`) THEN [Current month number of working days] ELSE [total month working days] END

Are you passing your campaign name in the utm_campaign parameter in the URL? How are you tracking your ad campaign?

Hi @mhouk The connector will only give back data it's programmed to return so in your case it won't be included in the connector. You can create your own Domo connector to interact with the Qualtrics API and pull the exact information you need if you have technical expertise. You can learn more about writing custom Domo…

Why not just do a left join in an ETL on your lookup table based on the InsCo field to pull in the Reclass value? This way you don't have to keep tweaking a regex

You'll need to start specific and then work your way down the list to be more generic with a case statement that way the more specific (BC or BW in your case) will be evaluated first. CASE WHEN `Col_ori` LIKE 'BC%' THEN 'H' WHEN `Col_ori` LIKE 'BW%' THEN 'H' WHEN `Col_ori` LIKE 'B%' THEN 'B' END

You can't rename the legend values. Those are pulled directly from the values in your series. You could utilize a CASE statement in a new beast mode to conditionally set a value and use that as your series. CASE WHEN CONCAT(`value1`, `value2`) = 'Value1 Value2' THEN 'abc' WHEN … END

Do you have any sorting going on in your chart? Also to simplify your beast mode you can use the LAST_DAY function to get the number of days in the month instead of having to use a case statement like you are: SUM(`any_hva`) / MAX(DAYOFMONTH(LAST_DAY(`event_date_id`)))

Are you getting any sort of error message or is there no data returning? What is the error?

The name of your beast mode you use to create the formula is your alias. So you can create a beast mode with the CONCAT function and reference it by the name you give it.

There isn't an option built into Domo for a fortnight. You could utilize a beast mode or an ETL and calculate the first day or the fortnight and graph by that date but it wouldn't really allow you to utilize the date picker on the chart as the data for the fortnight may span across other time periods like a month. You…

Have you tried connecting without the connection parameters? These are typically how you'd pass in values into your query if you're using parameter variables in the query.

Have you tried creating a new authorization / connection with Pinterest?

Beast modes allow you to add conditions to your aggregations dynamically based on what the user selected on the page as filters. Pre-aggregating your data in a Dataflow will set those aggregate values before you're able to do any dynamic filtering as the data is recorded directly into the dataset.

As a view is processed when the data is accessed/visualized in a graph so it can affect the performance of the graphs loading on a dashboard. Moving the logic into a Dataflow will remove the processing of the logic when loading the graphs/dashboard. The caveat to this is that if your dashboard is utilizing filtering your…

It depends on the platform and if they have an accessible API or not. There are other scripting language options you can do but require a bit of technical expertise like Python and Beautiful Soup or Selenium.

You'd need to do it in a formula tile instead of the replace text tile with something like this: CASE WHEN REGEXP_REPLACE(`Project Name`,'^.*\b(AR-\d{5})\b.*$','$1') <> `Project Name` THEN REGEXP_REPLACE(`Project Name`,'^.*\b(AR-\d{5})\b.*$','$1') END or alternatively: CASE WHEN REGEXP_LIKE(`Project…

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?