How to filter top N based on perticular week/Month

Hi Everyone,

I have created TOP N filter, but it is giving me top N based on overall value, where as
top N should be based on particular filed, for example top N in latest week or top N in latest Month. Can anyone help me in getting this done.

you can make calculated fields.

For this Month
ifelse(truncDate(‘MM’,{your_date})=truncDate(‘MM’,now()),{value},0)

Then do a top filter based on this field ^

Hi @Max ,

May be my previous problem statement was not clear, so explain it better I have attached my visual, below shown screenshot is top 15 merchants based on their YTD error count, but i want top 15 Merchant based on latest week error count (Latest).

Yes you should be able to do what I’ve done with some modifications.

ifelse(truncDate({week_date})=truncDate(‘WK’,now()),{value},0)

Then say top merchant_id based off of this ^ calculated field

1 Like