Line chart birt with multiple line on same Y axis

I want to show date on x-Axis and percentage on y axis but with 2 series on same Y axis.
Currently my output is coming like this where date is coming two time on x axis.
see Capture1.png
But I want output like this
see Capture2.png
How I can change it ? my data setting is like
see Capture3.png

Find more posts tagged with

Comments

pricher

Hi,
 
In the chart wizard Select Data tab, make sure Grouping and Sorting is enabled on your X-Axis date field, as shown here:

saachi

hello Mr. Richer, thanks for the reply. I enabled the Sorting but x-axis dates are coming multiple time here do you have any idea ? please see the attached screenshots.

pricher

HI,
 
Can you send your report design and possibly the data in a flat file?
 
P.

saachi

Please find attached rptdesign file and Result set from database

saachi

And i am expecting result like attached image where date should come one time on x axis.

pricher

Hi,
 
I think it has to do with the Percent Sum function you are using as the Grouping aggregation. When I try with Average, it works fine.
 
P.

saachi

It is now working for Average and for Sum also. But what is the difference if i used Avg or Sum ?
 
Thanks for the Help!