Page History

...

Overview

Time Series charts Time series charts show a series of data points, presented against an x axis that displays time in uniform intervals. Opposed to Unlike categorical charts, time series charts can effectively shows show gaps in the data through the use of these uniform time intervals.

<iframe width="700" height="394" src="https://www.youtube.com/embed/0ZAY1dZ_kdo?color=white" frameborder="0" allowfullscreen></iframe>

Enabling this option when using a date or timestamp as a Label in a chart also provides additional functionality:

1. Yearly Comparison
2. Units
3. Visible Unit Selection
4. Date Slider

Image Removed

These functions are discussed below.

Using time series charts gives you access to additional features, such as yearly comparisons, unit adjustment and display options, and a date slider. These are described below.

Enable time series charts

Logically, you can use time series charts only when a time/date field is available in the horizontal axis.  The time series option is enabled on most chart types by default, but you can check by clicking on the triangle to the right of the date/time field, which will produce a pop-up menu.

Image Added

If Default shows a tick beside it, time series is already on. However, you can select On if you want to ensure it always remains on, regardless of chart type.

...

Anchor
yearlycomp yearlycomp

If you have a line chart which is time series spanning more than one year range, you can use this option to split the single line into 12-month groups for easy comparison. When using this option, the units are set to month and cannot be changed.

1. Using the information above, ensure that Time Series is enabled for your chart (this requires a time/date field in your X axis)
   In our example, we have created a chart using the Ski Team view, with Invoiced Date in the Horizontal Axis field
   Image Added
2. Click on the Settings tool Image Added to display the Chart Settings dialog box
   Image Added
3. Click on the Time Format section heading to expand it
   Image Added
4. Use the toggle for Yearly Comparison to enable the option
   Image Added
5. Click on the Close button Image Added in the top right corner to close the dialog boxEnable Yearly Comparison through the chart Settings menu
   Image Removed
   Your line chart will now appear with refresh, and year available year will appear as a seperate line for each available year
   Image RemovedImage Added

Units

Change chart units

Changing the chart units lets you Allows you to select the time granularity of the chart independant display independent of what the underlying table displays.

1. Select the desired Units (granularity) in the chart Settings menu
   Image Removed

This won't alter any continuous units displayed along your horizontal access if your units. It might alter discrete units on your horizontal access. 

Note that this option doesn't appear while the Yearly Comparison option is enabled.

1. Ensure that Time Series is enabled for your chart (this requires a time/date field in your X axis)
   In our example, we have created a chart using the Ski Team view, with Invoiced Date in the Horizontal Axis field
2. Ensure that the Yearly Comparison option is toggled off (use the steps from the previous section if you need to check)
3. Click on the small blue triangle next to your date/time field to display the pop-up menu, then move your mouse to the Units option to display a sub-menu
   Image Added
   
   
4. Click on any of the unticked options and check your chart to see how it is altered (the bigger the difference between granularity, the more obvious the change will be)
   Image Added

...

Allows the user select the time granularity of the chart independant of the table.

1. Enable the Visible Unit Selection option through the chart Settings menu
   Image Removed
2. Your chart will now have a list of available units for the user to select from
   Image Removed

Enable visible unit selection

The Visible User Selection options lets you change the time granularity  on published charts without any affect on the underlying data. This gives end users more flexibility in what they can see in chart vizualisations.

Note that this option will not be available if the Yearly Comparison option is enabled. See the Yearly Comparison section above for details on where to locate this option.

1. Using the information above, ensure that Time Series is enabled for your chart (this requires a time/date field in your X axis)
   In our example, we have created a chart using the Ski Team view, with Invoiced Date in the Horizontal Axis field
2. Click on the Settings tool Image Added to display the Chart Settings dialog box
   Image Added

1. Click on the Interaction section heading to expand it
   Image Added
2. Click on the toggle for Visible Unit Selection to enabled it
3. Click on the Close button Image Added in the top right corner to close the dialog box
   To see the new option, let's preview the chart
4. Click on the Design tab in the top left corner of the page
   Image Added
   Your chart will now display a list of available units in the top left corner for the user to select
   Image Added
5. Click on the different options to get a feel for how the unit selector works
6. Click on the Charts tab in the top left corner of your screen to return to the Chart Builder

...

Date Slider

A date slider lets you Allows the user to zoom in and out of time-banded data.

<iframe width="700" height="394" src="https://www.youtube.com/embed/-l7KRn7P2Q4?color=white" frameborder="0" allowfullscreen></iframe>

1. Enable the Date Slider option through the chart Settings menu
   Image Removed
2. Your chart will now have a slider the user can manipulate to view subsets of the data
   Image Removed

Date Format Options

data on published charts. This option won't affect the underlying chart data.

Note that this option will not be available if the Yearly Comparison option is enabled. See the Yearly Comparison section above for details on where to locate this option.

1. Using the information above, ensure that Time Series is enabled for your chart (this requires a time/date field in your X axis)
   In our example, we have created a chart using the Ski Team view, with Invoiced Date in the Horizontal Axis field
2. Click on the Settings tool Image Added to display the Chart Settings dialog box
   Image Added
3. Click on the Interaction section heading to expand it
   Image Added
4. Click on the toggle for Date Slider to enabled it
5. Click on the Close button Image Added in the top right corner to close the dialog box
   To see the new option, let's preview the chart
6. Click on the Design tab in the top left corner of the page
   Image Added
   Your chart will now display a date slider just under the chart display
   Image Added
7. Hold your mouse button down on one end of the chart slide and move it, then release your mouse button to see the effect
   The data on your chart will expand or reduce to match the slider
   Image Added
8. Click on the Charts tab in the top left corner of your screen to return to the Chart Builder

Change the date format

You can change the date format on your charts to different styles more suited to your needs. This is available for all discrete Change the date format on your charts to a different style. This is available for all charts that support time series.

Note that this option will not be available if the Yearly Comparison option is enabled. See the Yearly Comparison section above for details on where to locate this option.

To check or change your date format for a series, follow the steps below.

...

Display metric in color field 

You can add a metric value to the color field when creating a time series chart. This will allow the metric field’s values to be represented in the chart with the help of colors.

Note that this option will not be available if the Yearly Comparison option is enabled. See the Yearly Comparison section above for details on where to locate this option.

1. Using the information above, ensure that Time Series is enabled for your chart (this requires a time/date field in your X axis)
   In our example, we have created a chart using the Ski Team view, with Invoiced Date in the Horizontal Axis field
2. If your chart is an auto-chart, consider changing it to a specific chart type that distinguishes Create a time series chart, using a time value. (You may want to select a non-auto chart which best distinguishes between colors, such as a bar chart.)Ensure that the time series is turned on through the time field’s menu, by selecting Time Series and then On. (Note: Time series is automatically turned on.)
   Image Removed
   
3. Drag a metric field to the color field in your chart builder.
   
4. The colors of the chart data will change according to the value of the applied metric field. A legend will also appear at the bottom to help distinguish between the color range. 
   Image RemovedImage Added
   As seen in our example above, the 2017 2019 bar has an average age of 2423, and is therefore a lighter shade of color than the 2010 bar which has an average age of 33.

...

Control null behavior

If your data is missing any values (that is, it contains NULL values), then you can select how to control the gap in time granularity. Time granularity refers to the date or timestamp unit of your chart (millisecond, second, minute, hours, day, week, month, quarter, or year). You can choose to do the following to control the gap:

...

 Note: This functionality is provided for all variations of line charts that support continuous time series, including auto-charts, line charts, stepped charts, combination charts, and overlay chart.

1. Using the information above, ensure that Time Series is enabled for your chart (this requires a time/date field in your X axis)
   In our example, we have created a chart using the Ski Team view, with Invoiced Date in the Horizontal Axis field
Ensure that your time series chart is set to continuous. 
2. Click on the blue triangle to the right of your time/date field, and from the pop-up menu that appears, select Time Data, then Continuous
3. 
   Image Modified
   
4. Click on the
date/time field menu arrow, and choose the
5. same blue triangle and this time select Fill in Granularity Gaps
option. Select
6. , then Apply to all Series
. Then choose On.
7. , then On
   This will enable
the Null Behaviour functionality
8. null behavior for your
line
9. chart
.
10. 
     


11. Image Modified

12. Next, choose the Null Behaviour option from the date/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)

13. Click on the same blue triangle and this time select Null Behaviour, then select Break
    Presuming your data has some null values, your chart will display a break in the data
    Image Added
    
14. Click on the same blue triangle and select Null Behaviour, then select Skip
    Presuming your data has some null values, your chart will join any gaps (which is the default behavior for
If Break is selected, the data will not be visible. 
Image Removed
If Skip is selected, the line will be joined (this is the default behaviour of
15. continuous time series charts)
. 
16. 
    Image Modified
If Zero is selected, then the missing gap will be treated as zero values. 
Image Removed
Simultaneously, you can use these settings through the chart settings option.
Image Removed
 You can also apply the null behaviour
17. Click on the same blue triangle and select Null Behaviour, then select Zero
    Presuming your data has some null values, your chart will use a value of zero for those null values
    Image Added

In addition to these null behavior options for line charts, you can also apply them 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 menu. 

Image Modified

...

...