Zoom To Chart For SQL Charts

The zoom function is a great way to add more depth to your timescale charts and allows your dashboard viewers to zoom into different periods of time. The zoom function lets you display more granular levels of time such as a monthly or daily perspective. For charts built using 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`;