GrantSmith Coach

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

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?

@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?

Currently there isn't a report to show all of the embed IDs but I'd recommend adding an idea to the idea exchange to improve the DomoStats connector

You can use a magic ETL and a formula tile to tack on the specific time your dataset was imported. It wouldn't match exactly to your system's date but would allow you to have a date tacked on in your dataset every time it's imported. You use a formula tile with the formula: CURRENT_TIMESTAMP() If your data is being…

A recursive dataflow will allow you to UPSERT your date (update if it already exist or insert a new record if it doesn't). So if you need to re-run your dataset it'll protect against duplicated data. The caveat to recursive dataflows is that by nature as the dataset grows the ETL will take longer to run as there's more…

a 429 error means that the connector has made too many requests in a specific amount of time and has hit the API Rate Limit (can either be x/day, x/second etc). The connector should intercept these errors and then wait the required amount of time to then resume the request without failing. This would need Domo to update…

How are you wanting the summary number to change? It should automatically update when you filter the card

Have you attempted to calculate the difference between today and the date field and then filtering on that field? DATEDIFF(CURRENT_DATE(), `date_field`) And then drag that into the filter and have it be between 1 and 8