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
Use Month as dimension in chart, and use the below expression
Hope this helps you.
Try with this expression
Expression: =Count(Distinct Document_name)/Count(TOTAL Distinct Month)
Hope it helps
i need to havit everything in a expression. I should use it as a formula
Total number of documents/total number of months and it should be calculated individually for each user.
Then use this expression
Check whether the attached application help you.
Retrieving data ...