GrantSmith Coach

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.

What are you looking to improve in your visualization? Some general things I look out for when designing dashboards and cards is to pull in only the information that is necessary, the more data you're processing the slower your visualizations will load and respond to things like filtering. Keep your dashboards simple, the…

There isn't an official supported API call you can do to get this information however you may be able to inspect the network traffic and determine the correct call and use that to pull your Embed IDs.

You can also simplify the conditions to: CASE WHEN `ORDER_DATE` >= CURRENT_DATE() - INTERVAL (DAYOFYEAR(`ORDER_DATE`)-1) DAY - INTERVAL 1 YEAR AND `ORDER_DATE` <= CURRENT_DATE() - INTERVAL 1 YEAR THEN 'YES' ELSE 'NO' END

Your STR_TO_DATE format is not quite correct. The first one isn't including the dashes that you've concatenated in there. The second is including commans which aren't included. Try something like this: CASE WHEN `ORDER_DATE` >= STR_TO_DATE(CONCAT(YEAR(CURRENT_DATE()-1), '-01-01'), '%Y-%m-%d') AND `ORDER_DATE` <=…

How do you know what Region and Sub Region each employee is in? You're getting extra rows because when you join based on a one-to-many relationship, each sub-region is created as a new record.

It appears that Facebook has changed their API and Domo's connector no longer works. I'd recommend logging a ticket with Domo Support for their development team to investigate and update the connector.

Typically when I'm debugging DDX bricks or custom apps within Domo I'll inspect the console and network traffic to see if there's an error being thrown behind the scenes to help diagnose where your error might be occurring. You can get to this by right-clicking on your webpage and selecting "Inspect"

Are you using the Table Data report or the Query report? Have you tried using the Query report and querying against the view?

CASE WHEN `Bill_To` LIKE 'PREFIX%' THEN 'Ignore' ELSE 'Include' END

Are you wanting the month filter to affect your data or can the month filter be ignored? If the month can be ignored you can configure the filter card on the dashboard to not apply the filter to your bar chart.

Are you looking for a regression line or your own custom formula?

Conragts @pauljames ! You might not be getting much sleep then @MarkSnodgrass . The top spot is mine this month. 😂

You're using a string for your sorting so it goes character by character so it's going '1', '11', '12', '2'. You need to return numbers to do proper numerical sorting: CASE WHEN MonthName = 'January' THEN 1 WHEN MonthName = 'February' THEN 2 WHEN MonthName = 'March' THEN 3 WHEN MonthName = 'April' THEN 4 WHEN MonthName =…

CASE WHEN `Program Guide URL` IS NOT NULL AND `Program Guide URL` LIKE 'http%' THEN CONCAT('<a href="',`Program Guide URL`,'">',`Certification`,'</a>') ELSE `Certification` END