Eclipse Community Forums: BIRT » Plotting series with different DateTime witout losing grouping functionality

Home » Archived » 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 07:08

Eclipse User

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 11:32

Eclipse User

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 04:07

Eclipse User

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 07:57

Eclipse User

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 11:39

Eclipse User

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 195 times)

Previous Topic:	Report clean up
Next Topic:	Crosstab page break down and across

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 12 00:21:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter