kbota 🟠

Thanks @Jaketh13, I will try that!

Yes, the MySQL statement is as follows: SELECT a.*, (SELECT SUM(`Sales 2017`) from retail_sales_2016_to_present_joined as b where a.`Date_1` >= b.`Date_1` and a.`Store Location_1` = b.`Store Location_1` AND YEAR(a.`Date_1`) = YEAR(b.`Date_1`) AND MONTH(a.`Date_1`) = MONTH(b.`Date_1`) ) as 'Sales 2017 MTD' FROM…

Thanks @ST_-Superman-_--another dojo member provided me with a MySQL statement that appears to be working, so I think I am good to go now! But thank you for responding and looking into this for me!

I am trying to use these same transforms to create a Running Total column for my store sales column--I have thirty stores and would like to have a column that shows each store's cumulative total sales for the month as of each date. However, when I try to use these transforms, it only returns values for the first store in…

Thanks @tomo! I must have missed the OneDrive connector when I was looking for connection options.

Thanks @AS, I will try that -- seems crazy that this feature isn't in Domo. I can't imagine I am the only person who has ever wanted to change the unit a scale counts by, if nothing else for easier readability.