Eclipse Community Forums: BIRT » Table of one month, sum data from timestamps ofone day

Help

Home

Home » Archived » BIRT » Table of one month, sum data from timestamps ofone day

Show: Today's Messages :: Show Polls :: Message Navigator

Table of one month, sum data from timestamps ofone day [message #1357359]

Thu, 15 May 2014 13:37

dome G.

Messages: 4
Registered: May 2014

Junior Member

Hi all,

warning first: i am totaly new to birt.

i have that sql statement:

SELECT *   FROM gp8.rc_orders, rc_reports
where gp8.rc_orders.Timestamp_PLC_Start between rc_reports.Starttime and rc_reports.Endtime

The table and output looks like:

ID_Machine  ID_Function	 Timestamp	OrderNo  	running_meters_needed	running_meters      Timestamp_PLC_Start  	Timestamp_PLC_End	Laufzeit	uc_offset_min

3	1	01.04.2014 21:35	3421418		2021	0		01.04.2014 21:34	01.04.2014 21:34	0			60				
3	2	02.04.2014 07:40	3421418		2021	2079	        01.04.2014 21:34	02.04.2014 07:40	256			60				
3	1	07.01.2014 05:01	3327005		2640	0		07.01.2014 05:01	07.01.2014 05:01	0			60				
3	2	07.01.2014 08:29	3327005		2640	2634	        07.01.2014 05:01	07.01.2014 08:29	208			60				
3	1	07.01.2014 08:30	3327004		240	0		07.01.2014 08:29	07.01.2014 08:29	0			60				
3	2	07.01.2014 08:44	3327004		240	234		07.01.2014 08:29	07.01.2014 08:44	14			60		
[...]

Now i want to make a month report.
From day 1 to 31 and not each timestamp.
I want to sum the "running_meters".
Should looks like:

3	1	01.01.2014 24044			
3	2	02.01.2014 35078

Have i to use an other sql-statement or can i use birt for doing it?

Hope you understand my problem.

cheers

Report message to a moderator

Re: Table of one month, sum data from timestamps ofone day [message #1371773 is a reply to message #1357359]

Wed, 21 May 2014 14:36

Kristopher Clark

Messages: 130
Registered: January 2013

Senior Member

dominik geiler wrote:
> Hi all,
>
> warning first: i am totaly new to birt.
>
> i have that sql statement:
>
> SELECT * FROM gp8.rc_orders, rc_reports
> where gp8.rc_orders.Timestamp_PLC_Start between rc_reports.Starttime and
> rc_reports.Endtime
>
>
> The table and output looks like:
>
>
> ID_Machine ID_Function Timestamp OrderNo
> running_meters_needed running_meters Timestamp_PLC_Start
> Timestamp_PLC_End Laufzeit uc_offset_min
>
>
>
> 3 1 01.04.2014 21:35 3421418 2021 0 01.04.2014
> 21:34 01.04.2014 21:34 0 60
> 3 2 02.04.2014 07:40 3421418 2021 2079
> 01.04.2014 21:34 02.04.2014 07:40 256 60
> 3 1 07.01.2014 05:01 3327005 2640 0 07.01.2014
> 05:01 07.01.2014 05:01 0 60
> 3 2 07.01.2014 08:29 3327005 2640 2634
> 07.01.2014 05:01 07.01.2014 08:29 208 60
> 3 1 07.01.2014 08:30 3327004 240 0 07.01.2014
> 08:29 07.01.2014 08:29 0 60
> 3 2 07.01.2014 08:44 3327004 240 234
> 07.01.2014 08:29 07.01.2014 08:44 14 60
> [...]
>
>
> Now i want to make a month report.
> From day 1 to 31 and not each timestamp. I want to sum the
> "running_meters".
> Should looks like:
>
> 3 1 01.01.2014 24044
> 3 2 02.01.2014 35078
>
>
> Have i to use an other sql-statement or can i use birt for doing it?
>
>
> Hope you understand my problem.
>
>
> cheers
>

Hi Dominik! Are you wanting to sum running meters in the footer? From
the palette there is an aggregation item that you can place in the
footer. Once you've dragged that onto the report you can select what to
aggregate and what aggregation function you want. If you want a running
sum you can use that or use some SQL magic for it too, let me know if
you have any questions :)

Report message to a moderator

Previous Topic:	External Connection - Netezza
Next Topic:	xls export failing for large data Birt 2.6.2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 03:02:42 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter