A
andre
I have really no idea on how to do this report:
I want to analyse some data from Week X till Week (X+6)
and take an average over that.
Then, I would like to run the same report for:
- Week (X+1) till Week (X+7) and take an average over
that, and so on for:
- Week (X+2) till Week (X+8)
- Week (X+3) till Week (X+9)
till Week Y till Week (Y+6)
Finally, I want to calculate the average of all averages
received from these sub-report.
I hope that this is kind of clear.
The application is for a clinic:
For Week X, how many new patients have we had and how
often have these patients come back in average over 6
weeks.
Then do the same for Week X+1, Week X+2, ...
Finally, I could say that for Doctor 1, over a period of 3
months, he sees new patients 4 times in average over the
first 6 weeks, while that for Doctor 2, he only sees them
2 times.
Thank you very much for your help.
I want to analyse some data from Week X till Week (X+6)
and take an average over that.
Then, I would like to run the same report for:
- Week (X+1) till Week (X+7) and take an average over
that, and so on for:
- Week (X+2) till Week (X+8)
- Week (X+3) till Week (X+9)
till Week Y till Week (Y+6)
Finally, I want to calculate the average of all averages
received from these sub-report.
I hope that this is kind of clear.
The application is for a clinic:
For Week X, how many new patients have we had and how
often have these patients come back in average over 6
weeks.
Then do the same for Week X+1, Week X+2, ...
Finally, I could say that for Doctor 1, over a period of 3
months, he sees new patients 4 times in average over the
first 6 weeks, while that for Doctor 2, he only sees them
2 times.
Thank you very much for your help.