MarkSnodgrass Coach

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…

You can actually get this field populated pretty easily using Magic ETL. Here's a picture of what your ETL would generally look like: Here's a breakdown of the steps in the ETL 1. Split your input dataset into to two datasets by using the filter tiles. Filter one to Product equals AUM. Filter the other one to not equal to…

@jaeW_at_Onyx is correct that you won't be able to do this in a beast mode, but you should be able to do this with the Rank & Window tile in Magic ETL utilizing the SUM and LAG functions. Here's a link to the KB article: https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_Rank_and_Window You…

Spoiler (Highlight to read)The following did not give me an error when trying it in Domo's MySQL : SELECT CAST(NULL as char) as mycol You could try that and see if that works for you.The following did not give me an error when trying it in Domo's MySQL :SELECT CAST(NULL as char) as mycolYou could try that and see if that…

You should use the DATEDIFF function to get this. You can also simplify your statement due to the way CASE statements process. Here is what I would suggest: casewhen DATEDIFF(CURRENT_DATE(),`CD (Start)`) < 90 then '3 Months'when DATEDIFF(CURRENT_DATE(),`CD (Start)`) < 180 then '3-6 Months'when DATEDIFF(CURRENT_DATE(),`CD…

If you edit your dashboard, you can click on Edit Content on each card and select Change Interaction. Then choose Open Card Details in New Tab. You'll have to do it for each of them, but then they will open in a new tab when you click on them.

I would consider using a different type of card for this type of visualization. Have you tried using a Scatter card and using the time as the x-axis?

Try going to the associated dataflow for that dataset and click on history. It is likely that the dataflow failed and that is why you are seeing the exclamation point on the resulting dataset.

In section 1 of your Group By tile, you would want to add your 4 columns (Date, Product, Publication, Channel). In section 2, select your Revenue column and choose Sum and give it a name such as Total Revenue. This should give you the total revenue when those 4 columns are the same.

Thanks @GrantSmith ! This worked great. I did the calculations in MS SQL, which doesn't have the MOD function, but it does a similar which just uses the percent sign. It ended up looking like this for the remaining days calculation. DATEDIFF(DAY,`EndDate`, `StartDate`)%7

I would try the String Operations and use the trim spaces function. There are likely some hidden spaces causing Domo not to see the names as the same. You could also quickly do this in a beast mode to see if that fixes it. Just use the TRIM() function to remove the spaces and then drag the new beast mode field into your…

You need to use your DATEDIFF evaluation in your case statement and not value1 since that is just a date. It would look like this: (CASEWHEN DATEDIFF (CURRENT_DATE(),`Value1`) <180 THEN 1WHEN DATEDIFF (CURRENT_DATE(),`Value1`) <365 THEN 2WHEN DATEDIFF (CURRENT_DATE(),`Value1`) <729 THEN 3WHEN DATEDIFF…

The issue is your AND statement in each sequence. You would need to re-state the DATEDIFF formula after the AND again. You might consider re-writing it in reverse order and it would eliminate the need to have the AND statement because CASE statements exit after finding a match to the condition. (CASEWHEN DATEDIFF…

Ordering the data in the table should not be necessary unless you just find it easier to look at it when you are in the data center and looking at the data of a dataset. Having said that, you could use the Rank & Window tile to order one dataset before the other if you really wanted it stacked in a certain way. Here is a…

If you make a beastmode that just has SUM('yourcolumn') and put that in the text value, it should sum up the values for you when no filter is selected.Otherwise, the textbox card is set to just grab the first value in the dataset.

It looks as though your issue lies in the first case statement not having a condition. What do you want your SUM / COUNT to equal to in order to use `Live` ? That part appears to be missing. Just before "then `Live`" you should have a greater than, or less than or equal to and a number. Hope that makes sense.

You might look into using a flex table to visualize this. It does MoM and YoY with colored percent change indicators really nicely. Just change your Date Filter to group by month or year to get the look that you want. Here is a link to the KB article.…

I think you are going to have better luck if you use the custom chart feature. You can upload any layout that you like as an svg file and then Domo will make it a heat map for you. Here is a video of how I did it on a human body. https://www.domo.com/help-center/videos/watch/Rj3iipg17hw This KB article was also very…