You can create dynamic chart aggregations using either regular & jinjia referencing.
(1) Using control cells with regular SQL
Use a case statement to set the date aggregations & axis title.
The full example:
(2)Using control cells with jinja references
Use jinja referencing to set the date aggregations. Learn more about jinja templating here. To see what SQL will be generated, select "Show compiled SQL" from the LHS design bar.
The full example:
---
See the full example in a canvas here.