Aggr Example 1

Data:

ID Region Days Program
1 MID 5 High
2 MID 5 High
3 MID 5 High
4 MID 5 High
5 MID 5 High
7 West 5 Mid
8 North 5 Mid
9 East 5 Mid
10 South 5 Mid
6 MID 100 Low

 

Capture.PNG

for Region=MID

column 1
sum(all)=125 count(ID)=6 125/6=20.83

column2
sum for Region=MID =125 count(ID)=6 125/6=20.83

column3
sum for Region=MID and Program=high=5 count(ID)=5 25/5=5
sum for Region=MID and Program=low=100 count(ID)=1 100/1=100 and (5+100) / 2 (2 diferent aggregatin)=52.5

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.