GrantSmith Coach

This would create a new field with the extracted value if it matches the logic, otherwise it's got a value of Unassigned. `field` needs to be replaced with the source field / column which has your campaign name data.

I'd recommend utilizing a custom PoP data dimension to allow you to display multiple years or deltas. I've done a write up on this in the past which you may find helpful. https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons

In Magic ETL JOIN tile can't join using a between clause however you can add a single column to each dataset, give it a name of "Join Column" with a value of 1, then join both datasets together based on this field and then use a filter tile to filter our records were it's not between the two dates.

DONE

Alternatively for a more customizable data solution you can utilize a custom date offset table and gives you a bit more flexibility graphing data than the standard PoP charts. I've done a write up on this before here:…

Have you tried using variables? You can conditionally return a specific column based on the criteria selected. You'd just have beast modes for the many different columns you want to display. You'd need to have the same amount of columns though as you couldn't have an empty column.

CASE WHEN REGEXP_LIKE(`field`, '^(A\d+).*$') THEN REGEXP_REPLACE(`field`, '^(A\d+).*$', '$1') ELSE 'unassigned' END You can use a formula tile and a regular expression to pull out the values which start with A followed by some numbers. ^ - Start of the line () - Match group to store the results found - in this case the…

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: https://developer.ukg.com/hcm/docs/soap-services

You'd need to specify the subfolder in the relative path parameter when configuring your connector. https://domo-support.domo.com/s/article/360043436773?language=en_US