
Re: Min and Max Limits in Chart
Devarasu R Jan 4, 2018 6:12 PM (in response to Denis LOMAKIN)HI,
u can add the top 10 rank condition inside scale range expression like below
Min(aggr(sum({$<Dimension = {"=Rank(SUM(Measure),4)<=10"}>} Index),Adviser_Name))
or
Min( sum(total <Adviser_Name> {$<Dimension = {"=Rank(SUM(Measure),4)<=10"}>} Index) )
P.S: updated your rank dimension, measure filed
Thanks,
Deva

Re: Min and Max Limits in Chart
Denis LOMAKIN Jan 8, 2018 1:26 PM (in response to Devarasu R)Hi Deva,
Sorry for a late replay.
My chart has alternative dimension, so I need the calculation of Min will be based on dimension that has been selected.
Is it achievable?
Thanks

Re: Min and Max Limits in Chart
Denis LOMAKIN Jan 8, 2018 1:29 PM (in response to Denis LOMAKIN)Also can you explain what do you mean by Rank Dimension and Measure?
It is should be based on Dimension selected by user and measure is a sum(index)


Re: Min and Max Limits in Chart
Denis LOMAKIN Jan 8, 2018 3:44 PM (in response to Devarasu R)Also, I tried to run your expression and it still giving zero as minimum value.
Just to give you an idea of chart.
Dimension is Adviser_Name (but there are alternative dimensions.
Measure is index but it is calculated measure that has different compenents and looks like this:
(if(sum({<$(vRollMonthCSE)>}(msrConvenienceIndexQuestionPoints1))>0,
sum({<$(vRollMonthCSE)>}(msrConvenienceIndexIndexScore1))/
sum({<$(vRollMonthCSE)>}(msrConvenienceIndexQuestionPoints1)),0)
+
if(sum({<$(vRollMonthCSE)>}(msrTreatmentIndexQuestionPoints1))>0,
sum({<$(vRollMonthCSE)>}(msrTreatmentIndexIndexScore1))/
sum({<$(vRollMonthCSE)>}(msrTreatmentIndexQuestionPoints1)),0)
+
if(sum({<$(vRollMonthCSE)>}(msrValueIndexQuestionPoints1))>0,
sum({<$(vRollMonthCSE)>}(msrValueIndexIndexScore1))/
sum({<$(vRollMonthCSE)>}(msrValueIndexQuestionPoints1)),0)
+
if(sum({<$(vRollMonthCSE)>}(msrQualityIndexQuestionPoints1))>0,
sum({<$(vRollMonthCSE)>}(msrQualityIndexIndexScore1))/
sum({<$(vRollMonthCSE)>}(msrQualityIndexQuestionPoints1)),0))*100.
vRollMonthCSE is a variable that used to display data for last N month based on selection.
Hope you can come up with something for me.
Thanks
