Hi team 👋 I'd like to share a request about virtual views. Date/timestamp columns in virtual views don't get time intervals (Day / Week / Month / Quarter / Year) the way date dimensions from dbt models do. Because of this, we can't switch date granularity on virtual view charts, and date filters always fall back to the day-level picker — for example, there's no way to pick "August 2026" with the month picker. This might be technically challenging, but I find date granularity really useful, so it would be great if time intervals worked on virtual view date columns too 🙏

👋 Thanks for your message - someone from the Lightdash support team will get back to you asap. Feel free to add any additional context to the thread here in the meantime (screenshots, app version if you're self-hosting etc.).

Hey 👋 Nice suggestion! I made an issue for this here: github.com/lightdash/lightdash/issues/26784 It'll be tracked in this thread!

I've upvoted issue #26784 for you! This issue has been requested by 1 other user. I'll notify everyone here as soon as it's fixed.

Thank you so much for the quick turnaround! celebrate

No problem - let me know how you get on with it - next time you make an edit and save an existing virtual view, or make a new one, these fields should automatically populate!