I have a line chart (grouped by month) created in the notebook editor, and I am able to change its click behavior to update a dashboard date filter. This works out as expected, when I click on a month the filter changes to that month.
When I try to do this with a functionally the same Custom SQL chart, it allows me to change the click behavior to update a dashboard date filter. However, when I click on a month, the date filter basically just resets and has no values.
This is the select statement from the custom SQL.
week, month) AS