northshorehiker Member

Thanks for the response, Adam... looks like version 3.1.5714.35059

Hi Adam-- Thanks for your message. I finally managed to figure this out... I had a stored proc (my back-end is SQL Server) that gave me exactly the dataset I needed, using a table variable for the table of months... I've since created a physical table of months that I'm now using instead, and Domo Workbench is handling…

Thank you for your response. My apologies, I probably should've included this in my initial message.,,, Ultimately, what I need to do is upload a dataset that contains one row for each of the past 18 months, along with some figures for each month. For some months, there will be no data, so it would just display zeroes in…

Or even if I could find out what the "dos and don'ts" are, for the SQL code being run by the Domo Workbench... It looks like table variables and temp tables aren't acceptable... can someone confirm this? Are there any more of these types of "gotchas"?

Thank you for the reply... My datasource is used to feed a number of cards and contains detail data rows, including a date/time field... I'm using filters to display a vertical bar graph of the count of the number of rows where a status-type field contains a particular value (y axis) for each month in the range. (x axis).…

Did you ever manage to get a solution for this? I'm currently dealing with a very similar issue. Thanks much!