I am trying to create a timeseries chart in a report which has two pens. One pen depicts production counts and the other an ideal production goal line. This works fine in the Vision chart component because each pen is supplied with its own dataset from a SQL query. But, in the Report chart component it seems that both pens must be supplied by one dataset.
If I union the two together so that I have one column as a timestamp and one column for each pen this results in null values for one pen at each timestamp. The Report chart component breaks the drawn continuous lines when encountering the null values. Is there a trick to avoid this or a way to supply each pen with its own dataset like the Vision chart?