GrantSmith Coach

This will be much simpler to do within an ETL than attempting to do it within a beast mode. I'd recommend using a rand and window tile in Magic partitioned on the customer, sorted by the order time and calculate a Dense Rank to determine the order number / count for each specific user. You can also partition on the…

I'd recommend reformatting / pivoting your data into a structure such that you have a date and the type of date that it is. Respondent, Type, Date Respondent 1, List, 12/31/2022 Respondent 1, Complete, 1/3/2023 Respondent 2, List, 1/1/20223 Respondent 3, List, 1/2/2023 Respondent 3, Complete, 1/4/2023 Then do your grouping…

Do you want this to be affected by filtering the transaction type or is this to be across all transaction types?

this isn’t an option with the standard chart options. You can utilize a DDX brick and the Phoenix engine and some CSS to display the table without a border

Have you looked into using pfilters? https://domo-support.domo.com/s/article/4418999855639?language=en_US

Do you have any beast modes with window functions or aggregations? Any sorting being done on fields which aren’t being displayed in the chart?

What does your date range look like? Is it always the current month or is this changeable by the end user to display other months?

Think of a filter tile as trying to selected the rows that match a certain criteria. If you're using a filter formula you can invert the logic. So if you know the logic you want to remove add a NOT in front of everything encapsulated in parenthesis. NOT (`column 1` IS NOT NULL AND `column 2` IS NULL) If you take the…

In Analyzer you can select an aggregation for your Total field and select Sum, this will group all your other columns togethers.

What commands have you run to setup your app? Have you run domo init ?

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