MarkSnodgrass Coach

Your insert sql statement should be inserting into a table that you created in a previous step. Then, after you can reference that original table in a later step and it will have your inserted data. Here is a sample screenshot. The select statement that I perform in transform_data_1 will have the newly inserted row that…

Have you considered using the Magic ETL to do this? You could use the Pivot/Uncollapse Columns tile to do this along with a Combine Columns tile.

You can just use the date range filter to accomplish this by making sure order date is the date field being used in the date range filter and then choose Last and then enter in 60 for the days. It would look like this. Then use whatever chart type you want to display your information.

Have you tried using the Microsoft Exchange Connector? I'd be interested in finding out if it works for you. At my previous employer, and pre-Domo, I pulled Exchange calendar details of all our employees with MSGraph and then stored them in a SQL database. If this connector can pull the details, this would be a much easier…

I would take what @GrantSmith is suggesting, but do it in Magic ETL because it already supports the window function and you don't need to talk toy our CSM. Just use the Rank & Window tile and use the LAG function as suggested so that your difference between occurrences will show as another column. 

Did you try this? ROUND(AVG(DATEDIFF(`Investigation End Date`,`Investigation Start Date`)),0)

I wouldn't think that a beast mode would prevent it from rounding, but you could use the round function on the outside of your average function within the beast mode. You should be able to round it to zero decimals in there.

In the Chart Properties under General, place a check next to Abbreviate Values. Along with the zero decimal places you already have selected, this should do it. It is working for me.

Your BETWEEN statement needs to have the older date first, followed by the newer date, It should look like this, for example: WHERE `Dlvd_Date` BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND NOW()) AS Rolling_Week

Here's a screenshot of what it would look like in analyzer to backup my earlier post.

You can show the most recent day accessed by clicking on the pencil icon for the Days Acccessed column in the column list and choose MAX. You can also format the date to just show the date in the same edit area by clicking on Format and choose Date Shorthand. To get the difference between the first day accessed and the…

You should try what @jaeW_at_Onyx suggested in this thread: https://dojo.domo.com/t5/New-to-Domo-and-Admin-questions/Fill-down-values-in-a-column-in-DOMO-ETL/m-p/51399#M2410 You are on the right track using the Rank function.

Unfortunately, the Donut Chart is not built to do that. You would need to switch to the Pie Chart or the Tree Map to display values in each slice without hovering over them. 

You should be able to get the sort you want with the built in functionality. In the Chart Properties - General, there are two additional properties that you will want to use in addition to the standard Sorting property: Sort on Totals Sort Each Category Play around with these 3 properties (Sorting, Sort on Total, Sort Each…

I would try moving your ClientRiskLevel into the series and then see if the color rules take effect. You can move your client name to the tooltip fields then display the client name with the hover text settings.

@GrantSmith 's answers are spot on as usual. I think it is worth pointing out that you can use the date filter to only pull the last 12 months and that would save you the work of the beast mode, depending on what you are trying to do. Thought I would mention it as some people forget that it is there and all the options it…

I think you are referring to Filter Views that is in Beta right now, but you could be referring to something else.

I would get rid of your outer SUM function as I think it not necessary since you are already summing inside your case statement. I would suggest this: CASE WHEN `Year`=2020 AND `Month #` <=`Month # for Today`THEN (SUM (CASE WHEN `Unit price`>100 THEN (`SO Ordered Qty`*`Cases per Pallet`) ELSE `SO Ordered Qty` END) )ELSE…

@GrantSmith is highly skilled at Window functions and dates and can probably figure it out for you.

You could do this a couple different ways, but here is one for you: CASE WHEN 'Days Ago' >= 1 THEN DATE_SUB('Start Date', interval 'Days Ago' day)ELSE 'Start Date'END Hope this helps. 

By default, no you can't do this type of work in a beast mode. You can ask your CSM to enable "window functions in beast mode" and then you can use the OVER clause to accomplish. You could do this in Magic ETL very easily with its built-in functionality. You could use a Group By tile to group by ID and MAX(date) and then…

Is there always data in all 3 columns: Process, Lathe, Material? If you aren't seeing the left 4 characters of material when the process column equals the lathe column, I would doublecheck that the material column is populated when the process and lathe columns are the same. To troubleshoot, I would use a table card with…

If you are using MySQL, you could do this: SELECT Column1, Column2,CASE WHEN column1 = 'datapoint1' THEN DATE_SUB(column2, INTERVAL 1 MONTH)WHEN column1 = 'datapoint2' THEN DATE_SUB(column2, INTERVAL 2 MONTH)END as Column3FROM MyTable You can also do this in MagicETL, which might be worth doing if you are not comfortable…

Yes. You can do this in Magic ETL or in a beast mode. You would use the Set Column Value tile in the ETL. Here's a link to how to use it: https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/04ETL_Actions%3A_Edit_Data#Set_Column_Value In a Beast Mode, you would use the IFNULL function like this:…

When viewing a card (not editing) scroll down below the graph and click on the name of the dataset. This will take you to the dataset details page. Click on the 3 dots in top right corner of the page and choose Export Data. This will download the data for you. 

I have found that I can't trust the Preview window, regardless of how many rows I tell it to be in the preview. The row amount you choose (10k, 100k, etc.) only affects how many rows it will pull from your input datasets. It doesn't affect how many rows will show in the tile preview windows. Unfortunately, this means that…

Yeah, Domo doesn't support a comma separated list in the search box unfortunately. I can think of 3 hacks that would get you close to what you want to do: 1. Create a beast mode that has your e-mail addresses by using a case statement like: CASE WHEN 'email' IN (<your list of e-mail addresses>) THEN 'Y' ELSE 'N' END You…

You can turn on Quick Filter for the e-mail address field. This will make it show up for all users of the card and they can use the search box to search the list and select as many as you want. If you want to group the e-mail addresses, you can create a Beast Mode with a CASE statement that would group e-mail addresses…

Yes, you can use one instance of Workbench to connect to multiple Domo instances. Just click on the key icon (Accounts page) and then enter the Domo instance that you want to connect to. You'll have to have credentials for each instance, but other than that, it will work just fine.

Yes, you can overcome this with a few additional steps. Here is what you would want to do: 1. Add a 3rd connection from the input to dataset to a Select Columns tile and just select the month column. 2. Connect a Remove Duplicates tile to that tile and choose Month to get a distinct list of months from your dataset. 3. Add…