Set Zoom For Chart Interactivity



A great function to add more interactivity to your charts is the Zoom option. The Zoom option in datapine enables you to drill down into time scale charts and display a lower time hierarchy such as month to day. For charts built with SQL you will need to add the Command dp_zoom to the Date field to enable the zoom function.

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`