This blog is a tutorial showing you how to Switch between two date ranges. E.g from a monthly view to click into a have a daily view.
![](https://www.thedataschool.co.uk/content/images/2022/10/Switch-dates.gif)
Step 1: Create a custom dates for the date ranges you want
![](https://www.thedataschool.co.uk/content/images/2022/10/image-443.png)
![](https://www.thedataschool.co.uk/content/images/2022/10/image-444.png)
![](https://www.thedataschool.co.uk/content/images/2022/10/image-446.png)
Step 2: Create a set on the date that you want to drill into. then create a calculation
![](https://www.thedataschool.co.uk/content/images/2022/10/image-448.png)
![](https://www.thedataschool.co.uk/content/images/2022/10/image-449.png)
Step 3: Configure your chart
![](https://www.thedataschool.co.uk/content/images/2022/10/image-450.png)
Step 4: Create a Set action from worksheet actions
![](https://www.thedataschool.co.uk/content/images/2022/10/image-452.png)
![](https://www.thedataschool.co.uk/content/images/2022/10/image-453.png)
then click on your chart and it should switch