I work for a company who's fiscal year starts in July. Therefore I want most of my reports to run from July to June. I can achieve this with custom date ranges that then need to be updated each year, or with some trial and error in the advanced json formula spot. But once I have the date range sorted, the "YTDSum" function seems to only recognize a Jan-Dec year, and starts from scratch in the middle of my chart. Does anyone have a clever solution or workaround for this? (or do I need to schedule some extra time for screaming in the fire stairs?)
