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
2 years 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.