Is there a way to calculate a rolling average across days?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I have a list of personnel, on each given day they may have 0-15 records with a score of 0 or 100.

Is there a way to build a chart type report to give me a rolling average of an individual personnels scores for each day?

IE: January 1 - Average is just January 1 data

January 2 - average score of  Jan 1 and Jan 2

Jan 3 - average score of Jan 1, 2, and 3.

etc

Photo of JessicaD_QB

JessicaD_QB

  • 90 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
You can do this a few different way, but the best is through a "months" table to summarize the data.

Can you describe your current tables and relationships? any other process details that can help us steer you more?