en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Stephen  
#1 Posted : Monday, September 30, 2013 10:04:19 PM(UTC)
Stephen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 7/24/2013(UTC)
Posts: 10

Hello,

I'm having some trouble getting my calculation to do what I want it to do.

This is the data I'm working with. http://i.imgur.com/kKbd4PO.png?1

Dimension 2 is a location (there are 3) and Dimension 1 is a domain that contains the scores shown.

I would like to get the average score across the domains per location. Everything I have tried so far gets me the average score across the whole system, I'm uncertain how to specify the location level.

This is what i would like to see, but instead of 1 column at the end, I would like 1 column per location (dimension 2).
http://i.imgur.com/qWBENT7.png?1

Thanks
Steve
Páll Bjarkason  
#2 Posted : Tuesday, October 1, 2013 8:25:42 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 154

Dear Stephen
As I understand your problem you want to calculate an average for each of the Dimension 2's.
If this is the case plz look at this post: http://www.targit.com/en/youtargit?g=posts&t=180
Best regards

Páll, CTS
Stephen  
#3 Posted : Tuesday, October 1, 2013 3:58:13 PM(UTC)
Stephen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 7/24/2013(UTC)
Posts: 10

That's correct Páll. I'll take a look at that post, thank you.
Stephen  
#4 Posted : Tuesday, October 8, 2013 8:47:44 PM(UTC)
Stephen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 7/24/2013(UTC)
Posts: 10

pallb@holb.dk wrote:
Dear Stephen
As I understand your problem you want to calculate an average for each of the Dimension 2's.
If this is the case plz look at this post: http://www.targit.com/en/youtargit?g=posts&t=180


Thanks a lot Páll. That was exactly what i needed.
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error