GrantSmith Coach

You can log in as an Admin and go to More > Admin > Dashboards, search for your dashboard in question then check the checkbox next to it. In the upper right select Add dashboard Owner.

You can use a window function for something like this: SUM(SUM(1)) OVER (ORDER BY `Score` DESC)

You can change the data label in the setting to use other fields or values so if you want two separate columns for tie tooltip you can put them into the tooltip values

Can you pass in filters based on the date such that start_date is between your date range and end_date is between your date range?

Because your website and domo are coming from different domains by default you'll get the CORS error which is a standard security check to make sure you're not attempting to access a website from a completely different website. This is to avoid click-jacking attacks. There isn't a way to avoid this except for turning off…

A Domo Brick is a simplified custom app. You can see in the upper left portion of the bottom data mapping tab the name of the dataset that's been mapped and which dataset it's mapped to. The manifest file is already created and deployed with a DDX brick. If you need additional control over the manifest file then you'll…

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: https://domo-support.domo.com/s/article/000005100?language=en_US 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: https://help.shopify.com/en/manual/apps/app-types/custom-apps#create-and-install-a-custom-app

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: https://domo-support.domo.com/s/article/360042926714?language=en_US 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.