I need a chart line where i can show evolution of days and how many diferents users have readed the document yet,
for example whe first day only 50% of the total users have reded yet the document, the second day 97% of the users have readed the document and so on, and i can see that in the 3 first day near 99% of the users have readed the document....
i think this line char like a line with acumulate difrents users, but if i only use the accumulated radio button QV sum all values, day by day... and if a user 1 logon in the first day, but logon in the second day again the QV in the second day acumulate the value 1+1...
i need that the first day count diferents users of the first day, second day count diferents users of the first day and second day together, not sum diferents users of the first day + diferents users of the second day...
the file that i attached is only an example, in real i have mor than 2000 diferents users and 30 days....
i don't know if i explain my problem right...
thanks for your answers
Earlier I misunderstood your problem, but I think, like Aaron Morgan mentioned, it would be best to flag each user's first access in the script itself. Then you can use the flag in your set analysis.
You can use an Aggr statement against the Date to return the minimum date found for each user, which would be the "first" time they access it - then when you're accumulating this would only count each user the first time they accessed.
Change your dimension to be:
Otherwise if you want to do this in your script, create a new resident table that calculates the minimum date per user, like:
Left Join ([Your Table Name])
Date(Min(Date)) as FirstAccessed
Group by User;
Then use "First Accessed" as your dimension, much as above.