GrantSmith Coach

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.

Views aren't scheduled to run, they're run when they're accessed. They're not materialized / saved in an actual dataset. If you're looking to materialize the view and store the contents of the view on a daily basis you can use it as an input in a dataflow and just write out the contents to a dataflow dataset.

You wouldn't want to order by your header as that'd have all the 0s first then the 1s so likely your row is at the end of your dataset. Try sorting based on your Row_Number field instead.

Try using a formula tile to set the value of a column to be 1 if it's = 'market' and 0 if it's not (or whatever logic you need to mark it as the start). Then use the rank & window to do a running total of the column.

You need to pass in the correct format string when converting your string to a date STR_TO_DATE(`date`, '%c-%e-%y') There a lot of references on format string codes on the internet but this is one you can reference:…