Set Zoom For Chart Interactivity



A great function to add more interactivity to your charts is the Zoom option. The Zoom option for charts in datapine enables you to drill down into time scale charts and display a lower time hierarchy such as zooming from year by month to month by day. For charts built with SQL you will need to add the function dp_zoom() to the date field on the X-Axis to enable the zoom function on dashboard.

showing databpine's zoom function


You can use the following command for demonstration if you are still in demo mode and connected to our demo database:


Select dp_zoom(DATE_FORMAT(`Sales`.`Date`, '%b %Y')) as Date, COUNT(`Sales`.`SalesID`) as Sales
From `Sales`
Group by 1
Order by `Sales`.`Date`;