I would like to create a bar chart that has as time dimension a cyclic group Day/Week/Month and as expression something that shows the number of total members at the end of the time period, not the average or sum , but the last row.
For example if Day is selected
| Day | Number of Members |
| 10.04.14 | 44776 |
| 11.04.14 | 44815 |
| 14.04.14 | 44854 |
| 15.04.14 | 44887 |
| 16.04.14 | 44921 |
| 17.04.14 | 44946 |
| 18.04.14 | 44946 |
| 21.04.14 | 44946 |
| 22.04.14 | 44952 |
| 23.04.14 | 44950 |
| 24.04.14 | 44962 |
| 25.04.14 | 44989 |
| 28.04.14 | 45000 |
| 30.04.14 | 45073 |
| 01.05.14 | 44920 |
| 02.05.14 | 44945 |
| 05.05.14 | 44969 |
| 06.05.14 | 45002 |
| 07.05.14 | 45056 |
| 08.05.14 | 45120 |
| 09.05.14 | 45139 |
| 12.05.14 | 45139 |
| 13.05.14 | 45179 |
| 14.05.14 | 45225 |
| 15.05.14 | 45247 |
| 16.05.14 | 45225 |
| 19.05.14 | 45309 |
| 20.05.14 | 45348 |
| 21.05.14 | 45369 |
| 22.05.14 | 45389 |
| 23.05.14 | 45410 |
| 26.05.14 | 45455 |
| 28.05.14 | 45455 |
| 29.05.14 | 45455 |
| 30.05.14 | 45455 |
| 02.06.14 | 45282 |
| 03.06.14 | 45443 |
| 04.06.14 | 45443 |
| 05.06.14 | 45442 |
| 06.06.14 | 45502 |
| 09.06.14 | 45502 |
| 10.06.14 | 45510 |
if Week is selected then I have
| Week | Number of Members |
| 2014/15 | 44815 |
| 2014/16 | 44946 |
| 2014/17 | 44989 |
| 2014/18 | 44945 |
| … | … |
that is for each week I have the number of members of the last day of that week
if Month is selected then I have
| Month | Number of Members |
| avr. 2014 | 45000 |
| mai 2014 | 45455 |
| juin 2014 | 45510 |
that is for each month I have the number of members of the last day of that month.
Since I work with business days, last day of week or month for me is the last data point I have for that week or month not the calendar day.
Does anyone know how to make such a chart?
