How to find average documents used in a month

[#1]

Hi i need a formula to find out the below scenario,

Average Number of documents Visited by a user per month. Where field to be used are.User_name ,   Document_name ,  Month

[jagan]

Hi,

Use Month as dimension in chart, and use the below expression

=Count(Document_name)/Count(Distinct User_name)

Hope this helps you.

Regards,

Jagan.

[CELAMBARASAN]

Hi,

     Try with this expression

     Chart:Pivot

     Dimension: Month,User

     Expression: =Count(Distinct Document_name)/Count(TOTAL Distinct Month)

Hope it helps

Celambarasan

[#4]

i need to havit everything in a expression. I should use it as a formula

[CELAMBARASAN]

Hi,

     Total number of documents/total number of months and it should be calculated individually for each user.

Celambarasan

[jagan]

Hi,

Then use this expression

=Count(Document_name)/Count(DISTINCT Month)

Regards,

Jagan.

[sridhar240784]

Hi,

Check whether the attached application help you.

-Sridhar