|
Re: Plotting series with different DateTime witout losing grouping functionality [message #855180 is a reply to message #854922] |
Tue, 24 April 2012 15:32 |
|
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 #868000 is a reply to message #867639] |
Tue, 01 May 2012 15:39 |
|
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 175 times)
|
|
|
Powered by
FUDForum. Page generated in 0.04338 seconds