Chart: average of last 3 months

[Arde]

Hi,

I am making a report of our maintenance time. How can I make chart that calculates average based on last 3 months.

Data:
{@FixingTime}=number (how many days the device was on repair)
{@RepairDate}=date (date when the device was repaired)

Chart idea:
month1 =average({@FixingTime}) of months 11-1
month2 =average({@FixingTime}) of months) 12-2
month3 =average({@FixingTime}) of months 1-3
month4 =average({@FixingTime}) of months 2-4
...

Thanks for help.
Arde

 

[Arde]

Hi again,

So is it possible to calculate average on your own daterange.

If that isn't possible how about based on recordnumber. Then average on the records 1 to 5, 2 to 6, 3 to 7 etc....

Don't really need to know if either is even possible.

Arde