When I truncate dates to month, week, etc I'd like the chart visuals to automatically pick up the date granularity, rather than defaulting to days.
i.e. when all of my dates are at monthly granularity, I want my dsate axis to intelligently handle for this, and say 'Sep 2023, Oct 2023' rather than 'Sep 1, Sep 15, Oct 1, Oct 15'. I can do date formatting in my query, but there would be a lot of overhead to handle for a drop-down where granularity could be day, week, month, etc.