DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to draw multiple line graph, look into this example.

4071Jun 26 2003 — edited Aug 28 2006

Hi friends,

i have a group wise data like below.
no of groups are upto 10.

SELECT group_name,to_char(trip_date,'DD/MM DY') trip_date,SUM(sold_kgs) kgs_sold FROM route_actual_sales WHERE sales_rep_id = '001' AND trip_date >= '1-jun-03' AND trip_date <= '30-jun-03' GROUP BY group_name,TO_CHAR(trip_date,'DD/MM DY').

i want to display graph like,
i took a LINE graph, under sub category i took staked lines. i want to display my 10 different groups sales in 10 different lines. i could nt get properly and it is giving 1 line 30 days,2 line the same 30 days and so on.. it is going upto 10 times of single graph size expanding to 10 times of single page.

i need X-axis with trip_date, Y axis Kgs sold, diffrent groups in diffrent colors.

Thanks in advance