Aggregating data by date and time on a chart based on user time selections with easy zoom

[momihail]

Hi all, given the table

Cars
NumberCarsSold Time
5  3/1/2019     2:00:00AM
10 3/1/2019     3:00:00AM
2  3/2/2019     2:00:00AM
2  3/2/2019     5:00:00AM
2  8/2/2019     2:00:00AM

I want it to be displayed in an Area Chart, with Y axis = Sum(NumberCarsSold) and X axis = Time, and give the user the functionality to filter the time interval in which data should be displayed.

When the user selects an interval spanning months, the data automatically should be aggregated to a months level and it would have 2 peaks displayed, one for March(Yaxis=19 Xaxis=march) and one for August(Yaxis=2 Xaxis=august),as shown in this picture

When the user clicks on a month selection (eg. March) the data will be zoomed in to a Day level and there will be 2 corresponding peaks, one for `Yaxis=15 Xaxis=1` and one for `Yaxis=4 Xaxis=2`. If he clicks on the corresponding Day entry, the time entries corresponding to that day will be shown as shown in this picture

For now i am able to obtain almost the desired functionality with a Time Slicer and a ZoomCharts Advanced Time Series Visual, however the latter doesn't offer some of the features for free (e.g. setting the desired unit for initial state of the chart, choosing the type of chart - only bar chart is available for free).

Is there any other way to achieve the desired functionality? Thanks!

[v-jiascu-msft · Accepted solution]

Hi @momihail ,

The problem here could be changing the aggregation level automatically. The Area chart won't change the X-axis by the Slicer. How about creating several bookmarks?

Best Regards,