on 09-11-2008 8:53 PM
Hi,
I created a report to know the number of access of an url.
So the report look like that :
URL Number of access
www.google.ca SUM(of the URL www.google.ca)
I want the most visited to be the first record in my report.
If I have this information in my database.
www.google.ca
www.espn.com
So at the end I want this result :
www.google.ca 3
www.espn.com 1
How I can do that ??? The only thing I can do right now is a group on the URL but if I do that I have this result.
Can I do a formula and group on this formula or the only option I have is to change my query and give the number of access in the query ??
Regards,
Hugo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As you've grouped on the url and have a summary field (count) - now go to Report | Group Sort Expert and make it a TopN report based on your summary (count) for the group (url).
Enjoy!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.