| data question [message #249752] |
Wed, 25 July 2007 15:48  |
Eclipse User |
|
|
|
Originally posted by: aconner.geodecisions.com
I am creating a crosstab in birt that looks at 2 different grouping
variables, the summed data in the middle is simply a count of individual
events that occur in the appropriate grouping variables.
A B
A 2 4
B 1 5
So 2 people are AA, 4 are BA, etc.
I want to highlight any of the count values that are higher than the
average value for the cells. in the example above, the average value is 3
(12 events divided by 4 possible groups) What function can I use to
calculate this average value? I understand I need to know the number of
rows and columns, then I need to get the total number of events. I assume
this means I need 3 bindings(1 for rows, 1 for columns, 1 for total count)
What functions can I use to create these bindings?
I know very little about javascript, so I apologize if this is very simple
to accomplish.
thanks,
Adam
|
|
|
| Re: data question [message #249817 is a reply to message #249752] |
Wed, 25 July 2007 20:09  |
| Eclipse User |
|
|
|
Originally posted by: aconner.geodecisions.com
I found out how to get the total number of events, now I need a way to cound
the unique values in the groups.... any ideas? anyone?
"Adam Conner" <aconner@geodecisions.com> wrote in message
news:d4e16569cc039df9adc23094c5b5bb22$1@www.eclipse.org...
>I am creating a crosstab in birt that looks at 2 different grouping
>variables, the summed data in the middle is simply a count of individual
>events that occur in the appropriate grouping variables.
>
> A B
> A 2 4
> B 1 5
>
> So 2 people are AA, 4 are BA, etc.
>
> I want to highlight any of the count values that are higher than the
> average value for the cells. in the example above, the average value is 3
> (12 events divided by 4 possible groups) What function can I use to
> calculate this average value? I understand I need to know the number of
> rows and columns, then I need to get the total number of events. I assume
> this means I need 3 bindings(1 for rows, 1 for columns, 1 for total count)
> What functions can I use to create these bindings?
>
> I know very little about javascript, so I apologize if this is very simple
> to accomplish.
>
> thanks,
> Adam
>
|
|
|
| Re: data question [message #250109 is a reply to message #249817] |
Fri, 27 July 2007 00:50 |
 Rima Kanguri
Messages: 110
Registered: July 2009 |
Senior Member |
|
|
When you define the data cube, you can define a measure with function =
COUNTDISTINCT
--Rima Kanguri
"Adam Conner" <aconner@geodecisions.com> wrote in message
news:f88am8$o7t$1@build.eclipse.org...
> I found out how to get the total number of events, now I need a way to
cound
> the unique values in the groups.... any ideas? anyone?
>
> "Adam Conner" <aconner@geodecisions.com> wrote in message
> news:d4e16569cc039df9adc23094c5b5bb22$1@www.eclipse.org...
> >I am creating a crosstab in birt that looks at 2 different grouping
> >variables, the summed data in the middle is simply a count of individual
> >events that occur in the appropriate grouping variables.
> >
> > A B
> > A 2 4
> > B 1 5
> >
> > So 2 people are AA, 4 are BA, etc.
> >
> > I want to highlight any of the count values that are higher than the
> > average value for the cells. in the example above, the average value is
3
> > (12 events divided by 4 possible groups) What function can I use to
> > calculate this average value? I understand I need to know the number of
> > rows and columns, then I need to get the total number of events. I
assume
> > this means I need 3 bindings(1 for rows, 1 for columns, 1 for total
count)
> > What functions can I use to create these bindings?
> >
> > I know very little about javascript, so I apologize if this is very
simple
> > to accomplish.
> >
> > thanks,
> > Adam
> >
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.31016 seconds
] 
Search
Help
Register
Login
Home
