MarkSnodgrass Coach

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…

According to Microsoft's documentation "each private channel has its own SharePoint site". Within Teams, if you click on Open in SharePoint for the secure channel on the Files tab and look at the path and then do the same for a regular channel in within the same Team, compare the URLs and see if they are different. Here is…

That seems quite odd and that job became corrupted somehow. Can you try changing the schedule and see if re-saving a new schedule fixes it? Or try re-creating it as a new job? Those would be the first two things I would try.

If you are the owner of the account, you can go to the data center and then click on Accounts on the left. Then find the account you want to rename and click on the wrench on the right and choose Edit Account. This will let you rename the account.

I believe you need to start using the client ID and secret with OAuth 2.0 in order to connect now. You may want to review this page:

You might try appending your call outcome codes rather than joining. When appending, choose to include all columns. This should keep your data from duplicating, but still allow you to filter in various ways.

If the connector is living in Domo, then the computational costs will be on Domo's side and not yours and also should be negligible with one line of code. Having said that, you could let it come in as is and then use a Magic ETL dataflow to convert it to a datetime if Domo doesn't automatically recognize it.

If you switch your card type to Line + Grouped Bar chart type, you can set the last value projection for both the line and the bar.

In the analyzer click on "Add Calculated Field" in the bottom left and write the following formula: CASE WHEN 'bRentable' = 0 THEN 'Unrentable' WHEN 'bRentable' = 1 THEN 'Rentable' ELSE 'Unknown' END I used the else clause in case you have empty or null values and didn't want to assume it was rentable or not.