MarkSnodgrass Coach

You can combine multiple datasets in a dataflow (Magic ETL) which would create a single output dataset that you would use for the card. You could certainly have a dataset that has the list of reasons you want to include and then do a left join to your main dataset to develop your include/exclude list and create your totals…

Ah, sorry, I didn't catch that nuance in your example. I'm not sure how dynamic you need it, but you could create a beast mode that sums the rejected quantity based on which reasons you want to look at. It would look like this: CASE WHEN 'Reason' IN (<your list>) THEN 'Rejected Quantity' ELSE 0END You would then drag this…

You can do this very easily at the card level and not need to do anything at the dataflow level, which will give your user the most flexibility. For example, create a table and drag in the date, rejected quantity, and checked quantity into your column list and change the aggregation to sum for both of the quantity columns.…

It looks like they follow the color used for the x-axis. If you create a color rule for you x-axis field, the color you use will also be used for the min, max, average lines. Would be a good idea to allow it to be a chart property like the zero line. You could submit that as an enhancement in the idea exchange section of…

When creating a color rule, you can choose if you want to apply it to just that card, or to all cards that use that dataset. If your story page is only using one dataset, then you could build the rule once on a card and tell it to apply to all cards in this dataset and you would be done. If you have multiple datasets in…

The issue is that you are using double quotation marks in your then statement. It should be single quotes like this: CASEwhen `Active days` >= 90 then '90+ Days'when `Active days` >= 60 then '60-90 Days'when `Active days` >= 30 then '30-60 Days'when `Active days` < 30 then '<30 Days'end

You should be able to paste your SQL into a basic text editor and make sure word wrap is turned off and then look for position 888. You could also post your SQL in this forum and people are happy to help you find the issue with your syntax.

To add to @GrantSmith 's solution, you may want to use some group by tiles along with the join tiles to get the totals you are looking for (it's unclear to me if data was already aggregated). Here's a screenshot of what that would look like. 

You could do this pretty easily in a beast mode with like this: CASE WHEN `emailaddress` LIKE '%@mydomain%' THEN 'Yes'ELSE 'No' END If you have Magic ETL 2.0, then you can use the formula tile and include this in there and that would work well. If you think you might need to edit this formula often, making it a beast mode…

I would check if you have anything in the sorting properties. That can throw off Domo's ability to count distinct.

I had a similar issue a while back. I believe it is a bug, but I didn't bother to submit a case for it. I wish I could remember exactly how I solved it, but I believe it had to do with row height and sorting. I would suggest making a copy of the card and then click the reset all chart properties button and remove all…

It looks like you didn't complete adding the transform in the workbench. Once you select the Shift Data Timezone Transform, click the + sign next to it. This will open up a new window and have you select which timezone your data is currently in. Select the Eastern Time Zone and then click Apply. It should then be listed…

When Domo receives timestamp data, it assumes it is in UTC time and then applies the necessary timezone shift to match what your company settings are. You can see what time zone your instance is set to by going to More - Admin - Company Settings (assuming you have access to this section). If your Excel file is storing…

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.