on 12-24-2012 8:18 AM
Hi,
I am trying to calculate an average as depicted in the picture below -
1) Same Day - Number of visits on a calendar day (I calculated this using Count of @SamDay - inserted a summary)
2) Calendar Date - Distinct count of days between a given date range (I used insert summary again)
3) I need to calculate the average # of visits during the date range i.e. Sum (Same Day)/Distinct count of (Calendar Dates)
FYI. The new calculation should be effective on each value in Group Level 1.(The calendar date is Group Level 2)
As both the base measures are inserted as summaries, I am unable use them in a formula for creating average.
Could anyone please help me in finding a resolution for this?
Regards,
psh
Hi Parminder,
You can use the Summaries and create a formula to show the average.
Go to the Formula editor and you should see the summaries you've created on the Panel on the top under "Report Fields".
The formula you need to create would be something like this:
Sum({same_day},{group1})/Disctinct Count({Date},{Group2})
Hope this helps!
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.