GrantSmith Coach

Can you expand on this a bit more? It seems you already have variance as a % in your pivot table?

Are the audit date and submit date fields or timestamp fields? I've written up an article previously on formatting the difference between two timestamps which may be helpful.

If you're having issues with the connector I'd recommend logging a ticket with support for them to look into it on the back end.

This is because your regex is searching for a mapping and then replacing that with the same thing it found. Because there is no REGEXP_SUBSTING you need to match the entire string and then it'll replace the entire string with your mapping. You can do this with the ^ (start of string) and .* (any number of characters) and $…

You'd need to do a cartesian join on your dataset with your mapping dataset, apply the rule, and then reduce your dataset back to the original size. Start by adding a new column called Join Column with a value of 1 to each your input dataset and your mapping dataset. Join these two datasets together on the new join column.…

The input dataset should be the one you're wanting to do PoP analysis on along with the calendar dimension dataset from the Domo Dimensions connector. It's good practice to filter out any unnecessary data as early as you can in the ETL to improve processing efficiency. If you don't need dates prior to last year remove them…

It's the grey canvas area your tiles reside. Click inside anywhere inside that area but not directly on a tile then do a control+v to paste the code in.

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.

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…