Number of days users have logged in by grouping

[#1]

I have a data set that shows the number of hits (cl_Hits) by user (cl_user) by day (cl_Day).

I would like to get to the following. The below will look at the time over the previous month (cl_month)

Days Logged in	Users	%
0	43	29.7%
1	22	15.2%
2-5	63	43.4%
6+	17	11.7%

I have had a crack at it but not got close.

After the above is done I would also like to have it by month (cl_month). see attached.

I can't send across the data set but if you need any more info please ask.

[#2]

Hi daniel,

Your attachment showing expected output.

Could you share source data with few data.

Karthik

[#3]

I cannot send across the source data, sorry.

Think of it as a raw data set like the below and I want to create the above table.

Date               User           Hits

18/01/2013     123432     15

18/01/2013     456789     32

18/01/2013     674353     51

19/01/2013     123432     8

19/01/2013     674353     43

[#4]

The main issue I am having is getting the grouping by days.