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