GrantSmith Coach

Have you used an SQL transform to add indexes to your two tables on id, id2 and date fields? Alternatively have you used the new MagicETL as that will be much faster.

Currently no, it's all or nothing when it comes to editing cards. You can't select specific cards a user is able to edit. I'd recommend adding this as an idea to the idea exchange because I'm sure others are needing this specific functionality.

Hi @NateBI You'll want to use a Magic ETL and Unpivot your data such that you have a column for the different types of clean and then use that column in your Pie Chart. The pie chart only supports a single value for the pie name.

they only thing out of the box that would handle this correctly is doing a year to date selection. What I recommend is to configure your own date offset dataset to do a more apples to apples comparison. I’ve written up on this method before…

It doesn't appear to be currently possible within the smart text on a title however you can utilize a notebook card and add a summary number to display the minimum or maximum values in your dataset. https://domohelp.domo.com/hc/en-us/articles/360043430233-Adding-a-Notebook-Card#4. I'd also recommend adding this as an idea…

Yes as the data is filtered to that specific range and you no longer have access to the prior period data. I recommend utilizing a custom period calendar date to allow you to still have the PoP values even if the data has been filtered to a specific time frame. I've written up on this before here: A more flexible way to do…

You can do some simple date manipulation to get the Monday of the current week with a Formula Tile `Date` - INTERVAL (CASE WHEN DAYOFWEEK(`Date`) = 1 THEN 6 ELSE (DAYOFWEEK(`Date`) - 2) END) DAY DAYOFWEEK returns a number between 1 (Sunday) and 7 (Saturday). The CASE statement is checking if it's a Sunday to subtract 6…

SUM only takes a single argument. You'll need to add them together. Note that I'm adding 3 sums together as it will handle nulls otherwise if I add CURRENT_INVENTORY + NONCURRENT_INVENTORY + OLD_INVENTORY and if any one of those values is null then the entire value will be null causing incorrect summations. SUM(CASE WHEN…

You need to put your condition inside your aggregation. SUM(CASE WHEN `Order Src` LIKE 'CSR' THEN `order_line_total_price`) END) Also - as a side note your LIKE 'CSR' isn't matching on any wild cards so it's expecting Order Src to be equal to exactly CSR. if you're wanting to see if CSR is anywhere inside the Order Src…

Are you using Magic ETL or MySQL ETL? Can you post a screenshot of. the tile / logic that's being used?

Currently Domo doesn't have a way to remove the borders. I'd recommend adding it an idea in the idea exchange for the product team to possibly review and have other users vote on.

Start with the calendar dataset from the Domo date dimension connector and left join your dataset to it on the date using a dataset view or ETL. Then use the calendars date field instead of your own. Left join will cause your missing data to be null but still have the dates from the calendar

Are these two users in the same group / need the same access? Have you thought about configuring a group and then sharing the cards with that group instead so any future users will get the access when added to the group?

Likely no, it won't work if it's not a direct link to download the file. You'll have to figure another way of getting the data out of their system (perhaps they have an API you can access?).

In the email connector have you configured it to attempt to download from a link? https://domohelp.domo.com/hc/en-us/articles/360042931954-DataSet-via-Email-Connector#3.1.

Depending on the size of your dataset and the processing needs you can do this in either MySQL (simpler but slower) or MagicETL (more complex, possibly slower depending on dataset size). MySQL dataflow allows for conditional joins so it's a simple query: SELECT a.`ipaddress`, a.`ipnumber`, `Country`, `Region`, `City` FROM…

@Casey_Tsujita Domo doesn't exactly support recursive queries as you've mentioned because they're on MySQL 5.6. For my use cases I ended up utilizing a Magic ETL dataflow and then self-join the dataset to itself to go down the recursive list and did it 20 times to handle up to 20 levels deep. It's not the most elegant…

You can utilize a formula to calculate the most recent Monday for the week: `Date` - INTERVAL (CASE WHEN DAYOFWEEK(`Date`) = 1 THEN 6 ELSE (DAYOFWEEK(`Date`) - 2) END) DAY A week prior: `Date` - INTERVAL (CASE WHEN DAYOFWEEK(`Date`) = 1 THEN 6 ELSE (DAYOFWEEK(`Date`) - 2) END) DAY - INTERVAL 7 DAY DAYOFWEEK returns a…

CASE WHEN `model` IS NULL THEN 'Ignore' ELSE 'Include' END You can then take that beast mode and filter it on your card for Include

Magic ETL isn't performing SQL under the hood so there's no SQL to extract from the ETL. It's all done using Apache Spark. You'd need someone to look through your ETL logic and then write then translate it into SQL.

You can't dynamically tell a page to filter on different values (filter on shift 1 / filter on shift 2) depending on the time of the day. You'd likely need to have a beast mode that calculates the shifts as either "Current" or "Other" and then have a default page filter where shift = Current.

Under Chart Types select Tables from the drop down. You're currently looking at the Popular charts. It'll be under Tables.

You can utilize a custom date dimension / period dataset to calculate the different metrics for each date and then utilize a beast mode to create the columns for last month / last year / quarter etc. I've done a write up on this method here:…

@louiswatson You can utilize a Magic ETL with the Alter Columns tile to convert the datatype of each of your columns and then use that in your cards instead of using beast modes / calculated fields. This way it's only done once and you can build your cards off the converted dataset instead of creating multiple calculated…

Assuming you're using the Phoenix DDX Scatter plot example here but you can specify the colors you're graphing in the options dictionary and then pass that into your Chart call when charting your graph. const customColors = [ '#002159', '#03449E', '#0967D2', '#47A3F3', '#BAE3FF' ]; var options = { colors: customColors,…

You'll need to reach out to Domo Support as this is likely an issue in the back end storing the data after it's received your data.

Did you update the schema via the API or just add the new field to your dataset you're attempting to upload? You need to make sure the dataset schema includes the new field otherwise it'll fail. Domo has an example of this in their pydomo documentation: What program are you using to access the APIs?

I've had an idea in the Idea Exchange for a while to have Domo allow admins to just go directly to the page without having to request access to the page. Feel free to up vote it here: https://dojo.domo.com/main/discussion/53435/add-grant-access-button-to-pages-for-admins

Alternatively just allow admins to automatically load into the page without having to request access or have it added to the page list.

\r and/or \n should work but it appears they don't. You can explicitly pass an enter character in your forumla tile for the time being: REGEXP_REPLACE(`address`, '~', ' ')