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
Thank you for the screenshot, appreciated!
Please check my example below:
SELECT AVG(VLR_VENDAS_BASE_SEM_DEVOL_SEM_FRETE) WHERE (Date (Data) BETWEEN THIS - 9 AND THIS)
I would substitute the "Day of Year (Data)" with simple "Date (Data)" attribute if possible.