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

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?

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.

Regards,
Giri