Hi
I'm using Product Build19.2.0.00.18
I have chart which is a line graph and have 2 series based on dates
when I put only one series, dates on x axis shows correct however when I add the send dates don't show in correct order
both the series return same dates and same number of rows.
series 1: select ticket_count , to_char(calendar_date,'DD-MON-YY') cal_Date from tickets_dates_v a order by calendar_date;
calendar_date is of type date.
series 2: where day is of type date.I have tried without to_char and same issue
select
to_char(b.day,'DD-MON-YY') cal_date, round((a.ticket_count - ( (a.ticket_count * b.lvl)/max_lvl)) ) ticket_count
from issues_v a, cal_v b, max_level_v order by b.day
see the below screen
Whats the possible solution for this?
Thanks
Archana