Good Morning!I need help to make a metic where I need to display the average sales for the last 10 days
I tried to do it this way and I was not successful
SELECT AVG(Sales WHERE (Date “in this case the day”) BETWEEN THIS - 10 AND THIS)
In short, I need to return the average sales volume of the last 10 days.
Thank you very much in advance!
Best answer by Iva Gasparekova
View original