1.Average of Sales/2.Rolling Average of : last 30 Days / Previous N Months

[Venkat.Metadata]

Hi Team, For the first time i am doing a bit calculations in Quicksight?

I am having a Date, Products, Sales

I want calculate: Pls
SUM:-

1. Sales of last 30 Day Sales
2. Sales of Rolling sum of last 30 days
3. Previous 6 Months Sales
4. Rolling Previous 5 Months Sales

AVERAGE:

1. Sales of last 30 Day Sales
2. Sales of Rolling sum of last 30 days
3. Previous 6 Months Sales
4. Rolling Previous 5 Months Sales

The above calculations will work based on the Date Range Slicer?

[Giridhar.Prabhu]

Hi @Venkat.Metadata

You can refer to this article for the computations of this nature. Please note that when you use this approach you are filtering data in the calculated field definition itself and should not filter the visual with the date range.

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Hi @lbl You can use the Relative Dates on the parameters (may need to make more parameters) to automatically default to a given date that represents the time period, and can use those in your table headers. It’s not as flexible as being able to write your own calculated logic, but you should be able to get most time periods represented using this (prefix each with ‘Month of’ or ‘Week of’, then put the parameter there… [image] [image]

Regards,
Giri

[Brett]

Hi @Venkat.Metadata,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @Venkat.Metadata,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!