Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Crosstab taking average of averages
Crosstab taking average of averages [message #1591644] Thu, 29 January 2015 17:06 Go to next message
Shayne Paddock is currently offline Shayne PaddockFriend
Messages: 11
Registered: December 2009
Junior Member
I'm trying to create a survey report which needs to take an average of a group of average scores. The problem is BIRT is calculating the overall average using all of the underlying data instead of taking the average of the 3 already computed averages (groups), is there any way to avoid this?

As an example, a group of questions could be:

Scale 1-100

How did you like these things about your school:

Teacher - 81.9
Library - 92.9
Playground - 99.3

I want the overall score to be 91.37
(81.9 + 92.9 + 99.3) / 3

But I'm getting a slightly lower number like 91.25 because BIRT isn't taking the average of the 3 averaged numbers (groups) but the average of all the scores in the group.

We are using BIRT 4.3.2 v2


Kindest regards,
Shayne

[Updated on: Thu, 29 January 2015 17:06]

Report message to a moderator

Re: Crosstab taking average of averages [message #1591664 is a reply to message #1591644] Thu, 29 January 2015 17:24 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member
Could you attach a simple example (using sample database) showing how you have this set up? Thanks.

Michael

Developer Evangelist, Silanis

[Updated on: Thu, 29 January 2015 17:24]

Report message to a moderator

Re: Crosstab taking average of averages [message #1591796 is a reply to message #1591664] Thu, 29 January 2015 18:59 Go to previous messageGo to next message
Shayne Paddock is currently offline Shayne PaddockFriend
Messages: 11
Registered: December 2009
Junior Member
I've taken a screenshot of the output.

What I want to do is generate an average score for Food & Beverage, and then generate an average score for Front Desk. I then want to take those two averages and calculate an overall average for the survey.

What is happening is BIRT is generating the average by taking the sum of the scores of the 15 questions and dividing by 15 instead of just the two averages.

index.php/fa/20658/0/


-Shayne

Report message to a moderator

Re: Crosstab taking average of averages [message #1592072 is a reply to message #1591644] Thu, 29 January 2015 22:37 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member
All you should need to do is select the correct measure grouping to aggregate over in your grand total aggregation expression. Take a look at the attached image.

index.php/fa/20659/0/

Michael

Developer Evangelist, Silanis

[Updated on: Thu, 29 January 2015 22:38]

Report message to a moderator

Previous Topic:RTC Version 4.05
Next Topic:Table Grouping and Sub Report Conflict
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 10:39:34 GMT 2024

Powered by FUDForum. Page generated in 0.03494 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly