How to create a filter to show the latest quarter

Question & Answer
, , ,
1

I try to use this calculation below to get the latest quarter:

ifelse(
{fiscal_year} = extract('YYYY', now())
 AND {fiscal_quarter} = toString(extract('Q', now())), 
1, 0
)

When i add this to the filter pane, it will show “No data”

2

Hi @Adebayo_Desile

Welcome to QuickSight community .

If the requirement is to apply the filter on the date field to show only the data for the latest quarter . Then you can create the filter on the date field and choose Filter Type as : Relative Dates and set the filter range to This Quarter .

image
image461×778 52.2 KB

Did this solution work for you? I am marking the reply as “Solution,” but let us know if this is not resolved.

Thanks for posting your questions on the QuickSight CommunityQ&A Forum!

4

Hi @Adebayo_Desile,
It’s been awhile since we last heard from you; did you have any additional questions regarding your initial topic?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

5

You can close the topic.

1 Like