How to query/chart on a fiscal year? Calendar/data dimension table?
This might not be exactly Filament related but I'm working with a Filament app so I'll ask here.
I need to chart some trends based on a fiscal year of Jul 1 - June 30. I'm wondering what the best way to go about this would be?
Should I build a calendar/data dimension table in the database or would you just use Carbon to limit your queries dynamically?
2 Replies
Solution
notice
flowframe/laravel-trend package