Last Updated: 24 Jan 2020 16:40 by ADMIN
Created on: 19 Feb 2019 17:26
Category: Chart
Type: Feature Request
Chart with baseUnit date aggregation: Add option to exclude date aggregate points on the chart for which no data exists in the datasource.

-- Problem:  Consider a datasource where at least two date fields span a large time frame.  We can build a chart that aggregates that data by small units (categoryAxis.baseUnits) such as 'days' or 'months'.  That chart however contains many empty data points and the 'real' data is difficult to locate on the chart.  This often requires zooming in and out many times to view the data one is looking for.  However, it is still very valuable to be able to group by day or month, and to view this data in one succinct image.

-- Demo: The best way to experience this is to use the following Demo

This dojo is from the 'Date axis' chart demo on the site under Kendo UI for JQuery.  Edit the example.  There are 17 values in the datasource.  Change the year on the last value to '2019'.  All current values have dates between 2011-2012.

-- Required Chart Setup: Create a chart utilizing the following chart options

series.aggregate = 'avg'

categoryAxis.baseUnit = 'days'

dataSource with fields that contain at least one large date span

-- Suggestion

Add option to hide date aggregates chart points where no data exists within the datasource.


-- Image

1 comment
Posted on: 26 Feb 2019 11:13
Hello Brian,

You can consider the following options for handling this type of data with the currently available Chart features:

1. Use a category axis of type "category" instead of date:

When categories are treated as discrete values, no gap will be shown.

2. Use a StockChart with a navigator, which makes navigation through this data much easier for the user and still keeps the aggregates and scale of the data:

Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.