I have a chart that needs to show the hours per day when the granularity is set to day and average hours per day when any other granularity.

I was planning to use the “Before Render Snippet” option, but this isn’t triggered when the date granularity is changed.