MarkSnodgrass Coach

@GrantSmith will know the answer to this one.

Domo has an API that you can work with to automate the process. You could be a custom api that extracts data from one of your systems and updates Domo.

That's hard to say without seeing some sample data, but rather than doing a full join, you should consider doing an append and include all columns from both datasets. It is a commonly recommended approach instead of joining the data.

A full join is going to give you all the records from both tables and join matching records where it can. An inner join would only give you the matching records and exclude all other rows. This KB article has some good visuals that explain the various types along with a video.

You would want to follow the steps outlined here:

Yes, you can split your data and rejoin the data in Magic ETL. You might also want to look make use of the select columns tile while you are in the ETL and remove columns that you don't think will be used, or branch columns off into separate datasets. Keep in mind, if you want to use a table card, that card type is limited…

Is that error referencing a column name, or the data in a particular column?

Domo's MySQL is version 5.6, which doesn't support window functions. I would suggest using Magic ETL to do this with the rank and window tile. If you have Magic ETL 2.0, it will run incredibly fast. Rank and Window KB Article: Magic ETL 2.0 KB Article:…

Here is an idea for you to try using Magic ETL, and if you are using 2.0, it will run very fast. Here's a sample visual of what I am proposing for you and will explain it further below. Look at your data and determine what the maximum number of columns are. In my example, I am assuming the largest row has 10 columns, so I…

The Domo Webform is a very quick way to enter in some data and test with it. You can find it when you go to the data center and click on cloud app and then enter in webform

If your beast mode is calculating correctly in the pivot table, you can use that same beast mode as the y axis in the bar graph and the sales date in the x-axis and then use the date range filter in the top right to tell it to graph by month.

@MattGo good point. I pulled that example from a flex table card, which is what I often to use to compare prior years and I don't have to select the compare to previous year date option. I agree that it would be nice if it was just a baked in option on the summary numbers, especially for period over period cards.…

You can create a custom summary number to get this information. Here is what I wrote for one of my cards to show the trend. ROUND(((SUM(CASE WHEN YEAR(`datereported`) = YEAR(CURRENT_DATE()) THEN 1 ELSE 0 END ) - SUM(CASE WHEN YEAR(`datereported`) = YEAR(CURRENT_DATE())-1 THEN 1 ELSE 0 END ))/ SUM(CASE WHEN…

Have you tried writing it like this: SELECT p.`id`, p.`name`, p.parent_id, c.`name` as childname, FROM `products` p INNER JOIN `products` c on p.id = c.parentid You could change the inner join to a left join in case there are products with no children and you want to still include those.

I'm assuming you are doing this at the card level. You can do this a couple different ways. If you don't need the blank records, drag the ID field into the filter section and tell it to exclude blank records. Then, your count distinct should work as is. If you need the blanks but don't want to count them you can write a…

If you know that your text is always going to start with "Email somedate" then you can use the substring function to extract the date. In this example, you would do SUBSTRING(textfield,7,10) to get the date. You could also wrap the STR_TO_DATE function around the substring function to format it in a particular way if you…

You need to join these two datasets together to make one dataset. The easiest way to do this is with Magic ETL. The below example shows you more than just joining, but the idea is that you can use the join tile to join your two datasets together. You would join on week. You might want to review this KB article to better…

There doesn't appear to be a way to choose your timezone. However, if you click on Advanced Schedule, It will show the time in the timezone your computer is set to next to the UTC time that you can edit.

The only spot to do that would be the description field which is just below the card title. You can notes in that field.

You are talking about datasets, so I am assuming you want to do this in a dataflow with Magic ETL. You can combine two datasets in Magic ETL with a Join tile. You would select Inner Join for the type of join and then select each of the fields that you want to use for your criteria. In your example, you would join on two…

The export should just mimicking what is in your actual data, so I suspect you have trailing spaces in your source data. You can easily fix this in Magic ETL or with a Beast Mode by using the TRIM function to eliminate any leading or trailing spaces.

@swagner Some sample data might help with troubleshooting what is going on here, but I also wonder if considering a different approach might be easier. Have you considered using Magic ETL to get the totals you need? You could use a Group By tile to group by salesperson and year, then use the Rank & Window Lag function to…

Are you familiar with drill paths in Domo? This will do what you are wanting to do and doesn't require any parameter passing as Domo takes care of that for you. You can watch this Domo video for a quick tutorial on it: https://www.domo.com/help-center/videos/watch/eB3jtaWAvAs You could also design your page as a dashboard…

That would be a nice feature if it did that. Unfortunately, you can only choose one interaction in the interaction filter. I would suggest submitting it in the Ideas Exchange section of the Dojo and see if it can be added to a future release.

@DataSquirrel there is a Domo user group Slack channel that I think you would enjoy being a part of. We also have weekly zoom meetings on various topics. @jaeW_at_Onyx can you get @DataSquirrel added to both?

@DataSquirrel I have not heard any talk of a pending upgrade of MySQL, but I would assume they would at some point. Domo is going to focus its resources on Magic ETL and Adrenaline Dataflows and will try and steer people to those offering as much as possible. It is cheaper for them if people use those more, and I would…

I don't think the CLI tool was intended to be used as a reporting tool. I believe it was created as a quick way to perform some bulk actions, such as permissions, groups, etc... Here's a link to the KB article.

Have you looked into the Domo Stats and Domo Governance datasets in the appstore? Many of these questions can be answered with these datasets and the Domo Stats quickstart will even build the cards for you that will answer these questions for you.

@Ashleigh You are missing the word interval DATE_ADD('DateCol', interval 12 day)

@jaeW_at_Onyx and @GrantSmith are the kings of window functions, so I am sure they can help you out. I would point you to these two resources: You can perform window functions in Magic ETL and they run very fast. Here is the KB article:…