need the repeat memebers in the last 7 days in the chart

[qlikapple]

Hi i have name and timestamp and date. my requirement is below

RETENTION RATE: names  reverting back to excel within 1 to 7 days business days will be a retained user. Overall user’s reverting back will add up to a percentage as compared to overall userbase generating the retention rate

The names which are hitting back on the (1- 7 days) count  i want ,

can anyone please help

[jyothish8807]

Could you please share your expected output ? I am not clear about your requirement.

Br,

KC

[qlikapple]

the names which are present are hitting back in diffrent dates.  the requirement is how many  users are hitting with in 7 days 

[qlikapple]

if the user hits on june 1st  and again the same user hits on june 2nd

I want the repeated users who hits  based on the timesatmp (1-7 days)

suppose user1 hits on june1 and june2nd and user2 hits on june2

i need on june 2nd user1 count

means on june 2nd 1user repeated user is there/total no of users  hitting on june 2nd

and the calculation will be

RETENTION RATE: names  reverting back to excel within 1 to 7 days business days will be a retained user. Overall user’s reverting back will add up to a percentage as compared to overall userbase generating the retention rate

[jyothish8807]

Hi ,

Please refer the attached.

[qlikapple]

Hi Jyothish

thanks for quick reply

i need bar chart on date wise from june 1st to june 5th . if  no repeated users are there , the count will show 0.

and  calculation will  be

june 2nd 1user repeated user is there/total no of users  hitting on june 2nd

can you please help

[jyothish8807]

see if this is what you want ?

[qlikapple]

hi , i think  my requirement  is not that

if u see

the user is hitting 3 dates june4th,5th, 6th

so  on chart it should show as on june 6th (x axes)

it should as count(repeated userid)/total(userid)

[qlikapple]

43816797

The user is hitting on june1st and june 4th

examplE: so on x axes  date June 4th it should show as ( count(reperated userid))/total userid

[jyothish8807]

Check this:

Br,

KC