Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Plotting series with different DateTime witout losing grouping functionality(Compare results of last month with this month using dateTime on xaxis)
Plotting series with different DateTime witout losing grouping functionality [message #854922] Tue, 24 April 2012 11:08 Go to next message
Ruben Durk is currently offline Ruben DurkFriend
Messages: 8
Registered: April 2012
Junior Member
I'm trying to make a graph where the user can, for example, compare the number of phonecalls of last month with the average of calls per month over the last couple years.
My data is logged every 5 minutes, and I love to be able to change the groupingUnit (sum each year,month,week etc). This way I can easily zoom in on the data.

So how can I draw a series of last month on the same axis as this month without losing the grouping functionality of datetime?

An example of what I have in mind:
Series 1: the number of calls each day in november 2011
Series w: the number of calls each day in november 2005-2011 (averaged)

I tried to post a link to a picture of what I have in mind, but I'm not allowed to until i have 25 posts.

The picture is located at i44.tinypic dot com/ 4nza.jpg
Re: Plotting series with different DateTime witout losing grouping functionality [message #855180 is a reply to message #854922] Tue, 24 April 2012 15:32 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Ruben

Do you have any data that we could build an example off of? If so it
would be great if you could put it in a txt, csv etc file and email it
to me at jasonweathersby at windstream dot net.
BTW for changing the group unit you could use some script like:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1222-Changing-the-Date-Grouping-on-the-X-Axis-of-a-Chart/

Jason


On 4/24/2012 7:08 AM, Ruben Durk wrote:
> I'm trying to make a graph where the user can, for example, compare the
> number of phonecalls of last month with the average of calls per month
> over the last couple years.
> My data is logged every 5 minutes, and I love to be able to change the
> groupingUnit (sum each year,month,week etc). This way I can easily zoom
> in on the data.
>
> So how can I draw a series of last month on the same axis as this month
> without losing the grouping functionality of datetime?
>
> An example of what I have in mind:
> Series 1: the number of calls each day in november 2011
> Series w: the number of calls each day in november 2005-2011 (averaged)
>
> I tried to post a link to a picture of what I have in mind, but I'm not
> allowed to until i have 25 posts.
> The picture is located at i44.tinypic dot com/ 4nza.jpg
>
Re: Plotting series with different DateTime witout losing grouping functionality [message #855932 is a reply to message #855180] Wed, 25 April 2012 08:07 Go to previous messageGo to next message
Ruben Durk is currently offline Ruben DurkFriend
Messages: 8
Registered: April 2012
Junior Member
Thanks for your reply Jason. I'll send you a file right away.

Re: Plotting series with different DateTime witout losing grouping functionality [message #867639 is a reply to message #855932] Tue, 01 May 2012 11:57 Go to previous messageGo to next message
Ruben Durk is currently offline Ruben DurkFriend
Messages: 8
Registered: April 2012
Junior Member
No one else tried to do this? Comparing the results of the current month with the average of previous months in a linechart?

I think there are two options as far as i can see:
- modify the dateTime of serie 1 to get the same dateTime values as serie 2
- Decompose dateTime to the separate year/month/day/hour/minute, identify a stepsize (like days), aggregate results manually and plot based on datapoints.

Both options seem cumbersome. Any ideas on this? Alternatives?
Re: Plotting series with different DateTime witout losing grouping functionality [message #868000 is a reply to message #867639] Tue, 01 May 2012 15:39 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

The issue is that all series must have the same number of data points
and a common x-axis value. One way around this if you are using 3.7.2
may be to use the relative time period element that was added. You
could create a cube in the report and add a crosstab. From the crosstab
create a chart view that shows the results. Take a look at the attached
example. The first element is a crosstab with a relative time
aggregation and then the second element is a copy of the first with a
chart view added.

Jason


On 5/1/2012 7:57 AM, Ruben Durk wrote:
> No one else tried to do this? Comparing the results of the current month
> with the average of previous months in a linechart?
>
> I think there are two options as far as i can see:
> - modify the dateTime of serie 1 to get the same dateTime values as serie 2
> - Decompose dateTime to the separate year/month/day/hour/minute,
> identify a stepsize (like days), aggregate results manually and plot
> based on datapoints.
>
> Both options seem cumbersome. Any ideas on this? Alternatives?
  • Attachment: prevyear.zip
    (Size: 9.84KB, Downloaded 139 times)
Previous Topic:Report clean up
Next Topic:Crosstab page break down and across
Goto Forum:
  


Current Time: Thu Sep 24 11:42:49 GMT 2020

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

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

Back to the top