Solved

# METRICS MAQL - AVERAGE SALES OF THE LAST 10 DAYS

• 5 replies
• 141 views

Userlevel 1
• Participating Frequently
• 8 replies
`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!`
icon

Best answer by Iva Gasparekova 1 June 2021, 16:27

View original

### 5 replies

Userlevel 3

Thank you for the screenshot, appreciated!

``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.

Userlevel 1

Thank you for the screenshot, appreciated!

``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.

`@Iva Gasparekova `
`It worked out!!I'm grateful for the help!!Thanks`
Userlevel 3

Good Morning!

``SELECT AVG(Sales) WHERE ("DATE_Attribute" BETWEEN THIS - 9 AND THIS)``

Could you confirm that "Sales" stands for a Fact or a Metric, which uses Fact, please?

Userlevel 1

Good Morning!

SELECT AVG(Sales) WHERE ("DATE_Attribiute" BETWEEN THIS - 9 AND THIS)

Could you confirm that "Sales" stands for a Fact or a Metric, which uses Fact, please?

`I'm wearing a FATO`

Userlevel 3

Awesome, happy to help  anytime!