Forum Discussion

AnneMcCarthy1's avatar
AnneMcCarthy1
Qrew Member
2 years ago

Filter Monthly, Quarterly, Yearly from one Date field

I have a table with a Maximum Date field. I'd like to create a chart that I can filter by Month, Quarter, and Year. I have managed to create 3 different charts (one for each), using formulas on that ...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
10 months ago

Can you give us an example of the output you want?  For example of the date is October 15, 2024, would the result need to be FY2025-Q1?

What is the format of the result? Note that if you want to have a report that sorts by Quarter, the year would need to be included if the report will cross fiscal years.