Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have an expression to find ranking based on drilldown dimension below. Its working and I want to show only Top 5 Rank. My drill down dimensions are Country,State and City
if(GetSelectedCount(CalDate)=0,
(rank(aggr(Count({<Entry-={$(vElectronic)},Profileadddate_MonthName={'$(=$(vCurrMnthProfiles))'}>}Entry)
/
Count({<Profileadddate_MonthName={'$(=$(vCurrMnthProfiles))'}>}Entry),$(vRankDrill_Profile)),4,1)),
(rank(aggr(Count({<Entry-={$(vElectronic)},Profileadddate={">=$(=Date(Min(CalDate)))<=$(=Date(max(CalDate)))"}>}Entry)
/
Count({<Profileadddate={">=$(=Date(Min(CalDate)))<=$(=Date(max(CalDate)))"}>}Entry),$(vRankDrill_Profile)),4,1))
)
Can anyone help me to limit my ranking to Top 5
Thanks in Advance
Try this?
if(GetSelectedCount(CalDate)=0,
(rank(aggr(Count({<CalDate = {"=Rank(Count(Entry),4)<=5"}, Entry-={$(vElectronic)},Profileadddate_MonthName={'$(=$(vCurrMnthProfiles))'}>}Entry)
/
Count({<CalDate = {"=Rank(Count(Entry),4)<=5"}, Profileadddate_MonthName={'$(=$(vCurrMnthProfiles))'}>}Entry),$(vRankDrill_Profile)),4,1)),
(rank(aggr(Count({<CalDate = {"=Rank(Count(Entry),4)<=5"}, Entry-={$(vElectronic)},Profileadddate={">=$(=Date(Min(CalDate)))<=$(=Date(max(CalDate)))"}>}Entry)
/
Count({<CalDate = {"=Rank(Count(Entry),4)<=5"}, Profileadddate={">=$(=Date(Min(CalDate)))<=$(=Date(max(CalDate)))"}>}Entry),$(vRankDrill_Profile)),4,1))
)