user17569

Hello, I'm trying ot use the amazon advertising app. Waiting to get the API connected to my developer account that I just created. One I use the client id and client secret now though, it says there is an error logging in.

I actually found a solution using the rank & window function in Magic ETC then using CASE in MySQL. I ranked the weeks in descending order in magic ETL which numbered the weeks in order from the most current week to the least current week. The I used the following case statements in mysql to get the latest 4 weeks for this…

Moving the 1 to the first instance worked on some level, but only when I pull in a long date range, i.e., 2 years. What I'm trying to do though, is pull sales for any date range, say 1 week or 1 month and compare those sales to the previous year sales during the same time frame. I tried using this query sum(CASE WHEN…

Thanks All! I'm going to play around with your suggestions and see how it turns out.