Skip to main content
Question

Report Builder - Taking daily totals and calculate the monthly average

  • August 17, 2023
  • 1 reply
  • 31 views

Hi,

I need to takes daily totals and calculate the monthly average for those daily totals.

The problem right now is that my report summarizes each individual action instead.

Someone can help me on this? Thanks!

1 reply

Forum|alt.badge.img+2
  • Expert ⭐️
  • August 17, 2023

You’re issue it your data comes in at a daily interval and you want to display as month?

 

Comes in like this?

 

 

You can click the dropdown of the date field in the group by and change it to month instead of the actual date value. This will group everything in that month.