on 09-09-2014 3:19 PM
Hi Guys ,
I am trying to do an average for a list of number that also have Negative number in it , for some reason the Average is coming not as i do regular calculation .
Following is the calculation what Webi is doing :
As Average :13
Display Unit Number | Metrics R4 |
---|---|
1 | 22 |
2 | 16 |
3 | 15 |
4 | 29 |
5 | 30 |
6 | 6 |
7 | 0 |
8 | 2 |
9 | 6 |
10 | -27 |
Average: | 13 |
Hi,
I would say you have identical rows which have been aggregated, or else your formula is based on another object.
Could you export data to csv to check exact content of your data provider ?
Regards,
Loic
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
so basically , the count is the days between two dates , when i include the date in the block then the Avg comes fine , but when i remove the two dates from the block , then the avg is wrong . Following are the screen shot
Display Unit Number | Metrics R4 | Qualification Visit Call Ac | Site Selected Ac |
---|---|---|---|
1 | 22 | 7/5/11 | 7/27/11 |
2 | 16 | 7/11/11 | 7/27/11 |
3 | 15 | 7/12/11 | 7/27/11 |
4 | 29 | 6/28/11 | 7/27/11 |
5 | 30 | 6/27/11 | 7/27/11 |
6 | 6 | 7/13/11 | 7/19/11 |
7 | 0 | 8/10/11 | 8/10/11 |
8 | 2 | 8/17/11 | 8/19/11 |
9 | 6 | 8/31/11 | 9/6/11 |
10 | -27 | 9/21/11 | 8/25/11 |
Average: | 9.9 |
Display Unit Number | Metrics R4 |
---|---|
1 | 22 |
2 | 16 |
3 | 15 |
4 | 29 |
5 | 30 |
6 | 6 |
7 | 0 |
8 | 2 |
9 | 6 |
10 | -27 |
Average: | 13.29 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please provide the snapshot for average calculation.
Regards,
Pranay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.