GrantSmith Coach

You'd need to utilize a scripting language like Python and the Domo and Sharepoint SDKs to programmatically query your folder, pull and parse the data and then ingest it into your Domo instance. There isn't a tutorial on how to do this specific use case but you could reference the documentation for each of the different…

Right now no, this isn't possible because it can't store multiple values into a single variable. You can post this idea to the idea exchange to see if they can add it but might be difficult from a technical limitation standpoint.

Currently this isn't possible with the direct Share point connector. You'd need to script this yourself to automatically ingest all of the files.

You need to reverse the order of your SUM checks because if the sum is more than 111 it's already more than 35 so it will return Tier 2 first and quit as it executes the first case that matches. Check for Tier 4 then 3 then 2 then 1. Also with your tier 3 check you only need to check for 71 because by logic all prior when…

If you remove the Location and Location Number fields from your table and then in the column fields for your orders, line counts, quantity and sales amounts you can select SUM as the aggregation method. This will add all of the different locations together for each of your metrics.

Hi @Logan_M@Logan_Jolly This currently isn't an option to restrict individual filters on a card based on who is viewing it. You could post this to the Ideas Exchange as potential feature that others could vote on.

DATE_FORMAT function if your friend in this case. You can format the date as a specific string format. You can find more information on the codes used here: https://www.w3schools.com/sql/func_mysql_date_format.asp DATE_FORMAT(`Date`, '%Y-%m-%d %H:%i:%s')

You need to tell it to display the percent of total. This can be done under Data Label Settings then using %_PERCENT_OF_TOTAL as the Text value.

You can't remove the filter or PDP icons but you can change the justification within Analyzer. For your column select it then go to Format - Justification and set it there.

What logic are you using to join your datasets together? If you're just joining on the department then you're joining every departments spend across all the days in your dataset. You need to make sure to join on the same dates. A better methodology would be to stack/append your data such that you have a date, amount and…

Assuming it's always 6 digits: CONCAT(LEFT(`Postal Code`, 3), ' ', RIGHT(`Postal Code`, 3))

You should add the timestamp to the data that changed / added and not the entire dataset. Do you have a screenshot of your Magic ETL for reference?

@NateBI That's currently the only way to do a Dynamic Pivot. There isn't anything built into Magic that would allow you to do a pivot without previously knowing the values. You'd have to use a MySQL dataflow as documented in that article.

If you split out the Numerator and Denominator into their own beast modes what values are you getting?

Use a formula filter and exclude the dw field in the Calendar dataset where the value is 1 (Sunday) or 7 (Saturday) `dw` NOT IN (1,7) Alternatively you can do two filter criteria separately to make sure dw doesn't equal 1 and dw doesn't equal 7.

Due to the limitations of the map chart type you can't default missing values to 0. You'll need to utilize an ETL to join to the states dataset and get a list of all the states and then fill in a 0 value. I'd recommend posting this idea in the Idea Exchange for the product team to review and have other users vote on.

Domo only displays data that it has in the dataset. If you want to display all possible combinations of campaigns you'd need to have each campaign listed for each day. Take your dataset, get a list of unique dates (select columns, remove duplicates). Do the same for campaigns. For each of those add a constant called 'Join…

Another method I like to employ is to utilize a data table and display the numerator and denominator in different columns / beast modes to help determine if each are being calculated as expected.

Using LIKE without a wildcard will match your string exactly. If you want to match the start of your URL with that string add % at the end of your URL string. LIKE 'https://climate.....%' With fixed functions you'll need to aggregate the aggregate because of how they function. Wrap your denominator with a SUM.…

Fixed function is your friend here. SUM(`Visitors`) / SUM(SUM(`Visitors`) FIXED ()) https://domo-support.domo.com/s/article/4408174643607?language=en_US

Sorry, forgot to have you pass in the 'm' and 'n' flags to the regexp_replace function to tell it to match newline characters with the . reference. m: Multiple-line mode. n: The . character matches line terminators. REGEXP_REPLACE(`text`, '^.*card_name: (.*)\nmeasureable_id:.*', '$1', 'mn')

Yes. That would affect the regular expression as there's a newline character prior to your measure_id. Try this version: REGEXP_REPLACE(`alert.message`, '^.*card_name: (.*)\nmeasurable_id: .*$', '$1')

Magic ETL formula tile should allow this: REGEXP_REPLACE(`alert.message`, '^.*card_name: (.*) measurable_id: .*$', '$1')

You can use a formula tile in Magic ETL to do a regular expression replacement REGEXP_REPLACE(`Team`, '( - EMEA)|( - AMERICAS)|( - GLOBAL)|( - APAC)', '') Alternatively you can chain REPLACE functions together in a Beast Mode: REPLACE(REPLACE(REPLACE(REPLACE(`Team`, ' - EMEA', ''), '- AMERICAS', ''), ' - GLOBAL', ''), '-…

So you just want to drop the last section after the last hyphen?

If your format is split by a hyphen you could use SPLIT_PART to get the first part of your string: SPLIT_PART(`Team`, ' - ', 1)

You'll need to share the dataset with the user so they can see it. PDP is applied after they access the dataset but need it shared to see it in the list first.

Has the dataset been shared with the user?

You can utilize the DENSE_RANK window function and a MOD function to calculate alternating lines and then conditionally set your row coloring. MOD will return either 0 or 1 depending if it's even or odd to allow you to identify alternating rows. MOD(DENSE_RANK() OVER (ORDER BY MAX(`User Pseudo ID`)), 2) Sort your table…

Try pivoting your data so that you have a year column, month column and a value column. Then you can use the Month as your x-axis and the year as your series with the value as your y axis.