Forum Discussion

momihail's avatar
momihail
Icon for Advocate I rankAdvocate I
7 years ago
Solved

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

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!

  • 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,

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    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,