ifelse(${DD}=“Transaction Volume” ,{Transaction Amount},${DD}=“Rule hit” ,({Rule hit count}),{Count of Fraud Transaction})
Iam Using this field in MAP Can we add a TOP 10 Filter , Since its a calculated field Its not allowing me to use parameter
Hello Please help this is urgent
Please review
hi @deepa.singh
you want the top 10 filter for the new field?
BR
I just want to show top 10 values in a MAP not more than that
you need to filter a dimension field top 10 based on you calculated field.
But what if select “custom”?
i tried with ifelse(${DD}="A" ,sum(Profit),${DD}="B" ,avg(Quantity),max(Discount)) as i assume you are using different aggregated fields.
Works for me
Top10