MarkSnodgrass Coach

I agree with @GrantSmith . Use the Group By tile and put name, account, date in the select columns. Then use the Max aggregate on the balance column.

@swagner Just watched someone encounter the same error as you. They fixed it by removing the group by column and then adding it back. Renaming the column does seem to be problematic though.

That is the scatter card type under Data Science. You can build it by putting your state/region in the X-Axis. Use a day calculation in the Y-Axis, such as DATEDIFF(CURDATE(),'dt') . Put your measurement, such as total infections in the Bubble Size field. You can add the state/region in the series to make different colors.…

Unfortunately, you can't include HTML in that card type. It would be worth submitting it in the Ideas Exchange for a future enhancement, though.

The closest thing you can do is to choose Sync Value Scales under the General Chart Properties. This will make the left and right be the same. I would think it would make more sense to have your percentage field be the line and your two order counts be the bars in the series. You'd then be able to format the line as a…

@Ashleigh Workbench 5.1 introduced partition support which might be effective for your use case. You can read about it here: https://domohelp.domo.com/hc/en-us/articles/360062446514-Workbench-5-1-Partition-Support

@Ashleigh might know the answer to this one. She is a power user of Form Builder.

You could use a pivot table and put invoice payor type as a column and that would create a column for each. You could also use Magic ETL to pivot the data using the Uncollapse Columns tile. See this KB article: https://domohelp.domo.com/hc/en-us/articles/360043427353-Magic-ETL-Tiles-Edit-Columns#11. You could also create…

cc: @GrantSmith @Ulzii

I would use a combination of the date range filter and a beast mode, but you could also do it all with a beast mode if you wanted. Set the date range filter to This Month Create a beast mode that looks like this: CASE WHEN 'arrangementdate' >= CURRENTDATE() THEN 'Include' ELSE 'Exclude' END Drag the beast mode into your…

Try removing the SUM functions in your beast mode and then in your target value change the aggregation type to SUM. I played around with the different variations and I was able to duplicate your issue when I added the SUM functions within the beast mode. Taking them out and using the SUM function in the aggregation type…

Is there anything in your Sorting properties? I'm wondering if LOB is in your Sorting properties and that is causing the x-axis to be repeated.

@melyeo I followed the steps in my instance and initially got the error that you did. I figured out it is because you used ticks around the table name and it wants single quotes. I'm guessing the autocomplete when you started typing the table name put the ticks in there. Your statement should look like this: CALL…

You will need to have Window Functions in Beast Modes enabled in your instance if it isn't already. You can ask your CSM to enable it. You can then create a beast mode like this: SUM(SUM(`yourfieldtosum`)) OVER(PARTITION BY `channel`) Obviously, replace yourfieldtosum with your two fields you are adding together. Once you…

@DANIH your final output should be SELECT * FROM transform2, not from the original input dataset. Not sure if that was just a typo, but your transform SQL looks correct that leads up to the final output.

Scott, Have you used GROUP BY to eliminate your duplicates? I just did that in ETL by using MAX on all the columns that could potentially be duplicated.

There is a writeback connector for MS SQL. You can read about it here: https://domohelp.domo.com/hc/en-us/articles/360043437013-Microsoft-SQL-Writeback-Connector I've not read anything about doing it in Workbench, though.

I assume you are talking about quick filters on a card. When adding a field to the filters section, just drag it in and don't pre-select anything. Just toggle the Display as Quick Filter to be enabled. As your data changes, new values will automatically show up and you won't need to do anything to the card.

I believe @jaeW_at_Onyx is familiar with stacker. He may be able to help.

You might want to look into the new Segments feature that was released. This might work for you. Here is a link to the KB article with video. https://domohelp.domo.com/hc/en-us/articles/4403089503383-Creating-Segments-in-Analyzer

You can use the QUARTER function to create a beast mode for your series like this: QUARTER('datefield') You can create another beast mode so that the x-axis always shows 1 - 13-ish for each of the quarters with this: WEEKOFYEAR(`datefield`) - ((QUARTER(`datefield`)-1)*13) Having said that, you can use period over period…

@jmcgurl you need to replace 'datefield' with the actual date field that is in your dataset. That was just a placeholder since I didn't know the name of your field.

@jmcgurl to @jaeW_at_Onyx 's suggestion that I totally agree with, you can create beast mode to just return the day of the week and bring that into your quick filters. You could do this: WEEKDAY('datefield') or you could use DAYNAME('datefield') which would Sunday, Monday, etc, which would be more readable to people than…

When troubleshooting, I try and break things down and also use a table card to easily see the results. I would try making 3 separate beast modes, one for each criteria in your beast mode and then put each of them in your table card. Something like this: Weekday beast mode field CASE WHEN WEEKDAY('datefield') = 1 THEN 'Y'…

Sorry, that slipped by me the first time. To get Sunday from the date, you just need to do this: WHEN WEEKDAY('datefield') = 1 AND `SESSION PURPOSE` = 'FULL_STORE_SCAN' AND `REGION CODE`= 'NA' Then COUNT(DISTINCT `STORE NO`) End Replace datefield with the actual name of the field that has the date.

Your case statement is close, but you need to use AND to include multiple criteria, like this: case when WEEKDAY(1) AND `SESSION PURPOSE` = 'FULL_STORE_SCAN' AND `REGION CODE`= 'NA' Then COUNT(DISTINCT `STORE NO`) End

In Magic ETL, I would do a LEFT JOIN with the customer table to the credit limit table so that you would have rows for every date. Next, use the Rank & Window tile and use the LAG function pull the credit limit from the previous date. You would then replace nulls with the last value This will get you close, but will be an…

I just had to do some password resets yesterday and I didn't have any issues. I would make sure the user's browser isn't putting in a saved password automatically for them.

You can use the SPLIT_PART function primarily to split these all out: First Name SPLIT_PART(TRIM(SPLIT_PART(`Name`,',',2)),' ',1) Last Name SPLIT_PART(`Name`,',',1) Middle Name SPLIT_PART(TRIM(SPLIT_PART(`Name`,',',2)),' ',2) Based on your examples, this will do the trick.

@user048760 in Magic ETL, you can use the String Operations tile and choose Right/Left Substring, select your column, enter 10 for the substring length and choose Left for side to start from. This will remove everything from the T and later, leaving just the date. Next, drag in the the Set Column Type tile and connect it…