10 Replies Latest reply on Dec 16, 2019 4:38 PM by Hilary Farrell-Oracle

    APEX 5.1 Combination Chart with Vertical bars or matching markers without matching dates?

    Keegan_W

      Hi,

       

      I'm in APEX 5.1.2 with the following sets of data:

       

      Data Set 1:

       

      input_date

      value

      12-FEB-2019

      -8

      24-MAR-2019

      -16

      28-APR-2019

      41

      27-JUN-2019

      43

      17-AUG-2019

      35

      05-OCT-2019

      32

      19-NOV-2019

      24

       

      Data Set 2:

       

      complete_date

      30-MAR-2019

      05-SEP-2019

       

       

      Currently, I have a line chart showing Data Set 1 only as follows:

       

      select to_char(input_date,'DD-MON-YYY') as input_date, value

        from data_table_1

       

      cusum_current.png

       

      Is there a way to overlay Data Set 2 to get something with vertical bars or with markers as outlined in these mockups:

       

      cusum_with_recal_lines.png cusum_with_recal_dots.png

       

      The goal of the visual is to show that something happened on the dates in Data Set 2 and to see if the trends of Data Set 1 change between those dates.  The dates of both data sets usually will not line up.

       

      Thanks!

       

      Keegan