Skip to Content
Author's profile photo Sara G Ayer

3 Simple Steps for Calculating Moving Average in Visual Intelligence

For doing Calculations in Visual Intelligence, just follow the simple steps below.

    1. Create a simple chart, With a time measure on y axis and months on x axis (line/Bar preferably)

Capture.PNG

          2. In the y axis measures you will see a drop down, click on it – > add calculation -> Moving Average.

Capture1.PNG

MOVING AVERAGE

  1. A pop up will appear asking for the values before and values after, Give the values as required.

Capture2.PNG

          3.The check box below asks you if the first month needs to be included or not.

And it’s done! J

Capture3.PNG

How is the Calculation behind the screens done?

Values before: Refers to,
Ex. “0” value here would give the calculated value from the first month. The calculation would depend on the value you enter for “values after”.

Values after:
Ex. “0” value here would give the same value for the first month alone.
For further clarification:

  1. When Values before and Values after : 0 & 0
    The MA, Returns the same values as the actual values (no MA calculations done)
  2. When Values before and Values after: 0 & 1 
    2 month MA is taken from the first month.
  3. When Values before and Values after: 1 & 0
    2 month MA is taken from second month. The first month’s value remains the same as in the actual.
  4. When Values before and Values after: 1 & 1
    3 month MA is taken from second month. The first month’s value will be 2 months MA of first two months.
  5. When Values before and Values after: 1 & 2
    4 month MA is taken from second month. The first month’s value will be 3 months MA of first two months.
  6. When Values before and Values after: 1 & 3
    5 month MA is taken from second month. The first month’s value will be 4 months MA of first two months.
  7. When Values before and Values after: 1 & 4
    6 month MA is taken from second month. The first month’s value will be 5 months MA of first two months.
  8. When Values before and Values after: 2 & 0
    3 month MA is taken from third month. The first month’s value will be the same as in the actual because of the zero in “values after”. Second month’s value is MA of 2 months.
  9. When Values before and Values after: 2 & 1
    4 month MA is taken from third month. The first month’s value is MA of 2 months. Second month’s value is MA of 3 months.
  10. When Values before and Values after: 2 & 2
    5 month MA is taken from third month. The first month’s value is MA of 3 months. Second month’s value is MA of 4 months.
  11. When Values before and Values after: 3 & 1
    5 month MA is taken from fourth month. The first month’s value is MA of 2 months. Second month’s value is MA of 3 months. Third month’s value is MA of 4 months.
  12. When Values before and Values after: 3 & 2
    6 month MA is taken from fourth month. The first month’s value is MA of 3 months. Second month’s value is MA of 4 months. Third month’s value is MA of 5 months.

Refer the screen shots below for further Understanding.

Capture5.PNG

Capture6.PNG

Note: I have checked the option “include self”, hence the values starts from first month itself.

Thanks,

Sara

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Sara,

      Nice blog.

      Keep it up

      Regards,

      Hari Suseelan

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you for you motivation  Suseelan

      BR,

      Sara

      Author's profile photo Former Member
      Former Member

      Hi Sara,

      You are welcome.

      Regards,

      Hari Suseelan

      Author's profile photo Modadugu Hemanth Kumar
      Modadugu Hemanth Kumar

      Informative blog  Sara G. thanks for sharing.

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Hemanth

      BR,

      Sara

      Author's profile photo rajesh bethamcharla
      rajesh bethamcharla

      Good one Sara....Keep it up... 🙂

      Author's profile photo Harleen Kaur
      Harleen Kaur

      Thanks for explaining this 🙂