Sorting values in BIRT Chart

Hi,

I have a data(as below) using which i need to generate a BIRT chart

Sprint Type Execrate RSD
Sprint1 Sanity 100 2012-01-01 05:30:00
Sprint2 Functional 100 2012-01-02 05:30:00
Sprint2 Regression 100 2012-01-02 05:30:00
Sprint2 Sanity 50 2012-01-02 05:30:00
Sprint3 Functional 100 2012-01-03 05:30:00
Sprint5 Sanity 66.6667 2012-01-15 05:30:00
Sprint6 Functional 100 2012-01-31 05:30:00
Sprint6 Regression 100 2012-01-31 05:30:00
Sprint6 Sanity 100 2012-01-31 05:30:00
Sprint7 Functional 100 2012-02-15 05:30:00
Sprint7 Regression 0 2012-02-15 05:30:00
Sprint7 Sanity 100 2012-02-15 05:30:00
Sprint8 Functional 100 2012-02-29 05:30:00
Sprint8 Regression 75 2012-02-29 05:30:00
Sprint8 Sanity 100 2012-02-29 05:30:00
Sprint9 Functional 100 2012-03-15 05:30:00
Sprint9 Regression 66.6667 2012-03-15 05:30:00
Sprint9 Sanity 100 2012-03-15 05:30:00
Sprint10 Functional 100 2012-03-31 05:30:00
Sprint10 Regression 50 2012-03-31 05:30:00
Sprint10 Sanity 100 2012-03-31 05:30:00

This value has been sorted based on the 'Date' field. When i give this data as an input to BIRT chart and trying to display the chart, it is trying to Sort it based on the 'Sprints' name. While Generating the BIRT chart i have given an optional y-axis field to group the values based on the 'Type'.

Now, I need to generate a BIRT chart(Stacked Bar Graph) with the x-axis as 'Sprints' and y-axis as 'Value',
sorted by 'Date' and it should be grouped by 'Type'. Can anyone help me out with this requirement?

Find more posts tagged with

Comments

akshatha_k

Hi,

I have a data(see the attached file) using which i need to generate a BIRT chart.

This value has been sorted based on the 'RSD' field. When i give this data as an input to BIRT chart and trying to display the chart, it is trying to Sort it based on the 'Sprint' name. While Generating the BIRT chart i have given an optional y-axis field to group the values based on the 'Type'.

Now, I need to generate a BIRT chart(Stacked Bar Graph) with the x-axis as 'Sprint' and y-axis as 'ExecRate',
sorted by 'RSD' and it should be grouped by 'Type'. Can anyone help me out with this requirement?

mwilliams

One option to make them in the correct order would be to uncheck the "is category axis" check box under the x-axis section in the chart wizard. This may not work for you because of the spacing. If you have data for more days, it might be ok though. Let me know. I'll work on making one that works with the category axis.

mwilliams

Oh, I think I misread something. You want the axis to be the Sprint, not the date, but sort it by date. I had something ready to post for the date on the x-axis. Is the different Sprint always going to be on a different date? Or will there be multiple sprints with the same date? If not, the report I made will still work, I just need to switch out the date with the sprint. I'll attach the report with that change.

mwilliams

Alright. Here's the report with optional grouping, using your data, with the axis sorted by date, with the sprint displayed. Let me know if this doesn't work for your actual report.

akshatha_k

Hi,
Thanks for the reply. But I'm not able to view the report design which you have attached. My BIRT eclipse is telling that, it cannot read the older version of report design. So, can u send me the report design of newer BIRT Version?

Note: Please find the attached file for the error.

Thanks,
Akshatha

mwilliams

Actually, I made the report in the newest version (3.7.2). What is your BIRT version? You could try changing the version info on the first few lines of the "XML Source" of the report I attached to match that of one of your other reports to see if it will work. If it doesn't, I'll make a report in your version. Let me know! Thanks!

akshatha_k

Hi,
I tried making changes to the xmlsource. But it didn't work giving some null pointer exception while saving. My BIRT version is as below:

Eclipse Business Intelligence and Reporting Tools SDK

Version: 2.6.1.v20100709-7m9f7NFT0z0-Im5IWab4F6
Build id: v20100915-1750

Thanks,
Akshatha

mwilliams

Ok. Here it is. I also added another way to do it. One way uses a couple computed columns to assign a non-date value ranking to the x-axis, so you don't have to mess with dates. The other uses the date and requires you to format the x-axis date a certain way to be certain your variable names and the labels match up. Use the txt file from the download above and be sure to change the location of the file in the dataSource. Take a look. Let me know if you have any questions!

akshatha_k

Hi,
It worked!! Thanks for the help..

Akshatha

mwilliams

Great! You're welcome! Let us know whenever you have questions!