Skip to Content
Former Member
Jun 27, 2008 at 06:04 PM

Rolling averages/sums for counts


I am a new user (business objects 12 relaease 2)

I would like to build a report in web intelligence displaying the average count of the number of records per day, where the average is calculated for a rolling window of days.

For example a rolling daily average count of records using a 3 day window would be caluculated by:

Summing the counts of records for the last three days and dividing by 3

I would like to include this rolling average in a table for a specified of time period, say the last 30 days. My table would have two rows the top row would be the date and would hgave 30 entries, inbe for each of the previous 30 days, The scond row would have the 3 day rolling average for each of the 30 days. This table format will also allow me to graph the table

An additional problem arises becasue there are some dates that have no data. I need to include those dates, but Web Intelligence won't display them. Is there a way of displaying dates with no values in the table?