Moving average question

Hi,

This is probably a very basic question.

I have a sales data set, with total sales and a date field (date granularity is on a daily level)

When doing a moving 3-month average for sales,  should I do this:

moving_average([sales],1,1,[date])

or

moving_average([sales],1,1,start_of_month([date])) ?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 1Replies
  • 18Views
  • 2 Following