Apply conditional format to line charts (time series) where value is null
The chart in the attached screenshots is a time series chart for the trend of internet traffic for the last 12 hours. Between 6 AM and 8.30 AM there are no datapoints available (meaning that the internet was down). I would like to set up the chart such that:
- Conditional format is applied to the time period where we did not receice any datapoints (thicker line, or a large rectangle area in the chart)
- The line shows null values as 0 between 6 AM and 8.30 PM, instead of extending the line from the last known datapoint to the next known datapoint.
Any ideas on how to fix this in Yellowfin?