Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Create a report with at least one date value.

  2. Navigate to the chart section.

  3. Select a chart that supports the time series. Ensure that you use the date fielda date/time field (not a plain text field that stores a date).

  4. Click on the series setting button in the chart builder’s header.



  5. Select the date/time field from the left side panel.

  6. Choose and apply a date format. 


...

  1. Ensure that your time series chart is set to continuous. 



  2. Click on the date field /time field menu arrow, and choose the Fill in Granularity Gaps option. Select Apply to all Series. Then choose On. This will enable the Null Behaviour functionality for your line chart. 



  3. Next, choose the Null Behaviour option from the date field /time field menu. Then select how you want the null values to be treated (click <here> for details on these values-link to above details)

  4. If Break is selected, the data will not be visible. 



  5. If Skip is selected, the line will be joined (this is the default behaviour of continuous time series charts). 



  6. If Zero is selected, then the missing gap will be treated as zero values. 



  7. Simultaneously, you can use these settings through the chart settings option.


     

  8. You can also apply the null behaviour to a trend line, when a Chart Function (such as Trend, Average, or Accumulation) is used. To enable this, switch on the Apply to all Trends setting from the date field’s menu (or the chart settings option). 

...