I have a line chart showing several series over time. I would like to show a vertical reference line at a particular date, like the blue line shown here:
The definition of the series is:
-- Get start and end points for a vertical line showing the current period start date
SELECT to_date(:P2_CASE_DT_FROM, 'dd-mon-yyyy') ctr_week_dt,
0 rp_4_week_ma
FROM dual
UNION
select to_date(:P2_CASE_DT_FROM, 'dd-mon-yyyy') ctr_week_dt,
MAX(100*mc.rp_4_week_ma) rp_4_week_ma
FROM pva_app.rts_tfa_ma_counts mc
WHERE mc.calendar_id = :p2_cal_id
AND mc.event_type = :p2_event_type
AND mc.event_name = :p2_event_name
AND mc.ctr_week_dt BETWEEN (to_date(:P9_END_DATE, 'DD-Mon-YYYY') - 365.25 * 4)
AND (to_date(:P9_END_DATE || ' 23:59:59', 'DD-Mon-YYYY HH24:MI:SS'))
Label: CTR_WEEK_DT Value: RP_4_WEEK_MA
What I end up with looks like this:
The query returns something like this:
CTR_WEEK_DT RP_4_WEEK_MA
1/7/2021 0
1/7/2021 23.5807860262009
Thanks for your help!