Build a chart with different parameters for each serie

Laewoon · 2012-03-07T09:57:40+00:00

Hello there ! I have a simple dataset that consists on just a : select * from my_table where CreationDate BETWEEN ? AND ? In my table, I have two important informations that I need for my chart : Price and CreationDate. I…

Laewoon

Hello there ! 
 
I have a simple dataset that consists on just a : 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>select * from my_table where CreationDate BETWEEN ? AND ?</pre>
 
In my table, I have two important informations that I need for my chart : Price and CreationDate. 
 
I must build a chart like this : 
 
<img src='http://i.stack.imgur.com/gUHO2.png' alt='Posted Image' class='bbc_img' /> 
 
The only thing I need to do is to show only the month for the X-axis and to make each serie (here represented as a line) representing one year. The goal is to compare the sum of the price per month, for each year. 
 
What I'm trying to get should approximately look like this : 
 
<img src='http://i.stack.imgur.com/Iwajb.png' alt='Posted Image' class='bbc_img' /> 
 
(Sorry for the quality, I'm not that good with GIMP

) 
 
The first issue is that I tried to set the X-axis to something like <pre class='_prettyXprint _lang-auto _linenums:0'>BirtDateTime.month(row["CreationDate"])</pre> but it throws me this error : 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>Fail to compute value from sort, group or filter expression.</pre>
 
The second issue is to set different parameters for each serie : 
 
- For the first serie, it should be : "2011-01-01" AND "2011-12-31" 
- For the second serie, it should be : "2012-01-01" AND "2012-12-31" 
 
Has anyone faced this case, and how did you solved it ? 
 
Thank you.

Find more posts tagged with

Comments

mwilliams

What is your BIRT version?

pricher

Hi,

You may be able to accomplish what you want by creating a few computed columns in your data set. You will need 1 column for each year you want to plot, and 1 more column for the month on the x-axis. For example, if your original data set returns a date and a price, the modified data set will have 3 more columns: Y2011, Y2012, and MyMonth. The expression for Y2011 and Y2012 will include a conditional statement that will test the year of the date and populate the column if it falls within the year. MyMonth is simply the month portion of the date and will be used on your x-axis.

You can take a look at the attached design for more information.

P.

Laewoon

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="97413" data-time="1331157764" data-date="07 March 2012 - 03:02 PM">
What is your BIRT version? </blockquote>
 
I'm using BIRT 3.7. 
 
I was wondering out if there was a way in the script section to make something like : 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>if (my_serie == current_year)
parameter["year"] = current_year
else
parameter["year"] = previous_year</pre>
 
Thanks

mwilliams

From the sounds of your original question, you could just create month and year bindings in your chart from your date field, then use the month value for your x-axis and the year value for your optional grouping value. Take a look at the attached report. It shows what I'm talking about. Let me know if this doesn't work with your data.