MarkSnodgrass Coach

@GrantSmith is correct that you can't use Workbench for that purpose. There is a MS SQL Writeback Connector, though. Here's the KB Article: https://domohelp.domo.com/hc/en-us/articles/360043437013-Microsoft-SQL-Writeback-Connector Here's a screenshot of the connector if you go through Data Center and Connectors and search…

This would get you the starting quarter. You would follow similar logic to get the ending month. CASE WHEN MONTH(DATE_SUB(`dt`, interval 6 month)) < 4 THEN CONCAT('1/1/',YEAR(DATE_SUB(`dt`, interval 6 month))) WHEN MONTH(DATE_SUB(`dt`, interval 6 month)) < 7 THEN CONCAT('4/1/',YEAR(DATE_SUB(`dt`, interval 6 month))) WHEN…

You can utilize the LAG function to get the total from the previous month, like this: LAG(SUM(`value`)) OVER (ORDER BY `activitydate`) These window functions are not enabled by default. You will need to ask your CSM to "enable window functions in beast modes" in order to make use of this. Also, you can view this post and…

You might consider using the Dataset Copy connector. It copies a dataset between different Domo instances. This is nice because then you don't have to give anyone access to your instance. Your team can construct datasets that they want to share and then provide the dataset id to the engineering team in the other instance…

Unfortunately not. It is driven dynamically by what you select in the date range filter. It would be a nice enhancement as I find it confusing to read at times.

Did you try this? SUM(CASE WHEN LEFT(`Stage`, 1) != '7' THEN `Pipeline` END) OVER () / MIN(`AOP`) OVER(PARTITION BY `SF Selling Lane`)

I would not recommend replace text for this. I would create a lookup table with the country id's and the country name and join that to your main dataset in the ETL. You can use Domo Webform or upload an Excel file to create the list of the values. Add that file to your ETL and join on country id. This will be much easier…

This should do it: SELECT 'date', 'Name', 'Revenue' FROM 'estimated' WHERE 'date' > (SELECT MAX('date') FROM 'daily')

If you can re-create that percent change in a beast mode then you can drag that beast mode into the sorting properties.

You might consider appending rather than joining. Choose the Include All Columns option when appending so that you don't lose any columns and then you have a single dataset that you can build all your cards off of.

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