last 4 weeks data

[#1]

Hi all,

I have a data like below. i need the results in bar graph.

invitation_id    date_created  user_signed  course_completed  

1                  02-04-2015             1                   1

2                  12-04-2015             1                   1

3                  20-04-2015             0                   0

4                  25-04-2015             1                   1

5                  26-04-2015             1                   0

6                  27-04-2015             1                   1

7                  28-04-2015             1                   0

8                  29-04-2015             1                    1

9                  01-05-2015             1                   1

10                02-05-2015             1                   1

11                03-05-2015              1                   1

12                03-05-2015              1                 0

I need bar graph on week basis. last 4 weeks data. the week format should same as in the image.

and also for last 7 days. please help me.

Thanks,

Pramod

[maxgro]

PFA