Zoom To Chart For SQL Charts

The Zoom function is a great way to add more depths to your timescale charts and allows your dashboard viewers to zoom into different periods of time. The Zoom option thereby lets you drill down into more granular levels of time such as from months to days. For charts built with SQL you will need to add the command dp_zoom in front of the date field to enable the zoom function.


Run the following command in your demo account to try the dp_zoom command and then enable the Zoom function for this chart.


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`