GrantSmith Coach

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

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 ! https://community-forums.domo.com/main/discussion/comment/81119#Comment_81119 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 =…

https://community-forums.domo.com/main/discussion/comment/81043#Comment_81043 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

You could attempt to inspect the network traffic and call the same APIs that Domo uses, but that isn't a supported method for extracting the data.

Card-specific color settings will take precedence over the default coloring. If you're changing the hex code for the color you already are using on the card in your brand kit, it'll add it to the existing card.

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

You need your </a> at the end of certification so that it actually makes the Certification clickable to the URL you define. CONCAT('<a href="',`Program Guide URL`,'">',`Certification`,'</a>')

This isn’t possible le currently unless you go down the custom app route. I’d add an idea to the idea exchange to see if Domo will add this ability

Depending on your prediction model it can be fairly compute-intensive so I typically leave this to a MagicETL to do the heavy lifting for me. Doing a self-service type model isn't really supported unless you're doing a very simplistic algorithm for your model. When doing it at the card level the Adrenaline layer isn't…

If you recreate the job are you able to get it to connect to Domo?

Have you tried using a Gantt chart? https://domo-support.domo.com/s/article/360043429133?language=en_US

@pauljames is correct, it'll prompt you to change ownership of the users. You can also swap ownership of Domo objects using the swap-owner command as part of the Java CLI tool that Domo provides.

@cepii - Why do you want to utilize Domo as a middle layer for this when a direct connection between ADP and Azure would likely be simpler and less complex?