Sparkline Date Filtering
Creating the Date Filter
To prevent creating an overwhelming and strange looking Sparkline that includes a date field as one of its axis it is recommended to use the Date Filter panel.
You can either define a Standard range or a Custom range.
This uses a predefined range starting from whatever anchor point you select.
Time period - The time between each data point. This can either be Day, Week, Month, Quarter and Year.
Number of (Time period) - Defines how many instances of the time period chosen are selected in the axis.
Anchor point - Defines where to start creating time periods from. You can choose from the current day (Today), the most recent data point ( Latest Data ), or from a Specific Date
This uses a predefined range starting from whatever anchor point you select.
Time period - The time between each data point. This can either be Day, Week, Month, Quarter and Year.
Start Date & End Date - Defines the starting and ending data points to create time periods between. This means the number of time periods is completely dependant on the overall time between the two data points.
An example of a result of using the date filter is shown below: - Using a standard range based on 12 Quarters from the Latest data point:
Last updated