Eclipse Community Forums: BIRT » Question on Total.max (wanting to evaluate over a values computed from grouped data)

Home » Archived » BIRT » Question on Total.max (wanting to evaluate over a values computed from grouped data)

Question on Total.max (wanting to evaluate over a values computed from grouped data) [message #147686]

Thu, 23 March 2006 21:36

Eclipse User

Hi -

I have the following data:
time name node weight stat
1143055386298 TestClusterA_xdblade11 xdblade11 2 1.879095097
1143055386298 TestClusterA_xdblade12 xdblade12 2 2.245486423
1143055386298 TestClusterA_xdblade6 xdblade6 2 1.313692117
1143055386298 TestClusterB_xdblade14 xdblade14 2 2.712973225
1143055386298 TestClusterC_xdblade13 xdblade13 2 1.964008839
1143055401308 TestClusterA_xdblade11 xdblade11 20 2.503407816
1143055401308 TestClusterA_xdblade12 xdblade12 20 2.628054582
1143055401308 TestClusterA_xdblade6 xdblade6 20 1.688361381
1143055401308 TestClusterB_xdblade14 xdblade14 20 2.962318488
1143055401308 TestClusterC_xdblade13 xdblade13 2 2.603752706
1143055416318 TestClusterA_xdblade11 xdblade11 20 1.940628236
1143055416318 TestClusterA_xdblade12 xdblade12 20 1.774214579
1143055416318 TestClusterA_xdblade6 xdblade6 20 1.724390554
1143055416318 TestClusterB_xdblade14 xdblade14 20 2.1522065
1143055416318 TestClusterC_xdblade13 xdblade13 2 1.758007498

I have it grouped as follows, first by row["name"].substr(0,12)
(cluster_group), and then by row["time"] (time_group):

TestClusterA:
1143055386298:
1143055386298 TestClusterA_xdblade11 xdblade11 2 1.879095097
1143055386298 TestClusterA_xdblade12 xdblade12 2 2.245486423
1143055386298 TestClusterA_xdblade6 xdblade6 2 1.313692117

1143055401308:
1143055401308 TestClusterA_xdblade11 xdblade11 20 2.503407816
1143055401308 TestClusterA_xdblade12 xdblade12 20 2.628054582
1143055401308 TestClusterA_xdblade6 xdblade6 20 1.688361381

1143055416318:
1143055416318 TestClusterA_xdblade11 xdblade11 20 1.940628236
1143055416318 TestClusterA_xdblade12 xdblade12 20 1.774214579
1143055416318 TestClusterA_xdblade6 xdblade6 20 1.724390554

TestClusterB:
1143055386298:
1143055386298 TestClusterB_xdblade14 xdblade14 2 2.712973225
1143055401308:
1143055401308 TestClusterB_xdblade14 xdblade14 20 2.962318488
1143055416318:
1143055416318 TestClusterB_xdblade14 xdblade14 20 2.1522065

TestClusterC:
1143055386298:
1143055386298 TestClusterC_xdblade13 xdblade13 2 1.964008839
1143055401308:
1143055401308 TestClusterC_xdblade13 xdblade13 2 2.603752706
1143055416318:
1143055416318 TestClusterC_xdblade13 xdblade13 2 1.758007498

I am wanting to have a table with the following information:
clustername maxinstances mininstances

where max/min instances is the maximum/minimum number of running cluster
members at any point in time. How can I go about getting this data in
BIRT? I would like to do something like
Total.max(Total.count(null,time_group)) ... such that I would find the
max of the count totals for each subgroup based on time. This however
does not appear to work in BIRT.

Any suggestions?

Thanks so much!!

Ann

Re: Question on Total.max (wanting to evaluate over a values computed from grouped data) [message #148688 is a reply to message #147686]

Mon, 27 March 2006 16:02

Eclipse User

Hi Ann. Use grouping elements by something and in the footer of the table
in the grouping section use the Total function. Then if you want to count
all the rows from the table try to use the Total function in the footer of
the table. I've used that and it worked with counting elements of
differents sections and total elements from a table.

Cristian

Previous Topic:	DataSet using Java Classes
Next Topic:	Scripted DataSet using jdbc Datasets

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 15 07:51:34 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter