GrantSmith Coach

Have you tried utilizing color rules and making the condition where isn't blank to apply to the cell and not the entire row? You may need to use a beast mode to set a default as it may not show empty value as an option. COALESCE(`Date Column`, 'MISSING DATE') Then set color rules based on the beast mode where the value is…

The custom app version does indeed work, it's just a matter of swapping out all your datasets on the cards and dataflows. Documentation on Domo's Shopify Custom App connector: Shopify's documentation on creating a custom app and getting an access token:

You can follow Shopify's documentation to create a custom app and get the access token here:

If you go under the Total section of that drop-down menu that's where you can change how the total row is calculated.

If you embed a dashboard there is an option for maximization to have a popup window for card details: Allow maximization — Opens a pop-up window of the card Details view for a card. This allows you to see more detail and interact with the card such as quick Filters and allows for additional export options.

What date field is the PoP comparison using in your date selector? Are you using any beast modes in your chart?

Yes if you click on the three dots in the dataset history on the version you want to revert to you can find the option.

I’ve also recently had issues with the Shopify connector where it’s saying it’s not authorized when I’ve authorized the connection already. I’m also waiting to hear back from support

If your data doesn't have data then it won't connect. You'll need to insert records in your dataset to have a contiguous line in your chart

+1 for LAST_DAY. An alternative is: CASE WHEN LAST_DAY(`Date`) < LAST_DAY(CURRENT_DATE()) THEN 'In' ELSE 'Out' END

You can refer to the KB article on setting up the SA360 connector: It walks through getting the ID and secret from Google's developer console.

By default the total is summed, if you select the Turnover % in your column list for your pivot table you can change how it's aggregated for the total record.

Are the values explicitly formatted as text in your Excel document? As a workaround, you can do as @DavidChurchman mentioned and just LPDD them in a MagicETL after it's been ingested.

You likely have some blank spaces in your 3rd party field. To handle these you can ignore empty fields: GROUP_CONCAT(DISTINCT CASE WHEN TRIM(COALESCE(`3rd Party`, '')) <> '' THEN ` 3rd Party` END)

the ds_get function doesn't allow for any encoding other than the default utf8. Two options here: Override the Domo class and write your own ds_get function to handle the latin1 encoding you have Bypass using the ds_get and just call the dataset.data_export function to return the data, then call pandas read_csv on your csv…

What type of file are you importing from? CSV? XLSX?

On the schema tab in your workbench job, set your ID field to be a string instead of a number. This should keep it as a string with the leading 0s.

CASE WHEN `Amount` >= CASE WHEN MONTHNAME(`Date`) = 'October' THEN 12 WHEN MONTHNAME(`Date`) = 'November' THEN 9 WHEN MONTHNAME(`Date`) = 'December' THEN 9 WHEN MONTHNAME(`Date`) = 'January' THEN 12 WHEN MONTHNAME(`Date`) = 'February' THEN 12 WHEN MONTHNAME(`Date`) = 'March' THEN 12 End THEN 'Goal Met' WHEN `Amount` >=…

Can you paste in your beast mode?

It should work, what type of error are you experiencing with the beast mode?

CASE WHEN MONTH(`Date`) IN (10,1,2) AND `Actual Goal` < 12 THEN 'Yes' WHEN MONTH(`Date`) IN (11,12) THEN AND `Actual Goal` < 9 THEN 'Yes' ELSE 'No' END

Why are you including the THEN '12' or THEN '9' clauses? This isn't valid syntax. You can only have one then clause for each where clause. If you're wanting to combine both values together you can use CONCAT: CASE WHEN MONTH(`Date`) IN (10,1,2) THEN CONCAT(`Actual Goal`, ' 12') WHEN MONTH(`Date`) IN (11,12) THEN…

This is because you don't have data on a monthly basis so it's not plotting the data. You could possibly use a window function to calculate the max value in the year for your line to get a straight line across for each year. MAX(MAX(`value`)) OVER (PARTITION BY `Year`)

Depends on the data and the chart being used. Some charts allow you to display missing dates on it but there actually isn't any data so it displays null. If the data actually has the dates and is set to null then your method would work.

I'm late to the party but another alternative would be to explicitly have a 0 record in your dataset for the months you don't have any hires.

Because you want to aggregate an aggregation you'll need to do it within Magic ETL. Start with the date dimension dataset and feed that into a formula tile to add a new column constant called Join Column with a value of 1. Take your original dataset feed it into a select columns to only select your product IDs and then…

Have you looked into using the Flex Table?

Card titles are stuck in the upper left. I'd recommend adding an idea to the idea exchange to allow for changing the alignment of the card. As a workaround, you could use a text/notebook card directly above your card, center the text, put your title there, and then uncheck the card display options on the card to not…

CURRENT_DATE() - INTERVAL (DAYOFYEAR(`ORDER_DATE`)-1) DAY - INTERVAL 1 YEAR DAYOFYEAR - Returns the day number of the year of the given date, ORDER_DATE in your example. (Jan 1 = 1, Dec 31 = 365/366) - INTERVAL (DAYOFYEAR(`ORDER_DATE`)-1) DAY - Subtract the number of days the current date is minus one so we get to day 1 of…

Due to security concerns, Domo only allows the HTTP, HTTPS, and MAILTO protocols. As @ColemenWilson mentioned you can use the mailto and pass in different parameters for the different email parts.