Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want those dealers who has consistent growth...
but top 5,10,15...on the choice of selection...
Top is based on the Increase column (Column 3- Column 1)...
Kindly help me with this issue..
I am able to achieve top 5 and consistent growth dealers separately..but when I put both the condition together..It doesn't work...
PFA qvw and data..
You want to see top 5 based on Increase column?
Firstly I want those dealers only...who are consitently growing in 4 months...
After that I want to apply...Top N Dealers.
Regards,
Kavita
Hello Kavita,
Trust that you are doing well!
I agree with stalwar1. You can further modify his solution to add -
1. Variable - vTop with definition Count(TOTAL Dealer)
2. Slider object for Top N analysis with Data = Variable(s) - vTop, Mode = Single Value, Value Mode = Continuous/Numeric, Min Value = 5, Max Value = 50 and Static Step = 5
3. Change the Straight Table expressions as below-
Month : If(Rank(Increase) <= $(vTop), Month)
Month+1 : If(Rank(Increase) <= $(vTop), [Month+1])
Month+2 : If(Rank(Increase) <= $(vTop), [Month+2])
Month+3 : If(Rank(Increase) <= $(vTop), [Month+3])
Increase : If(Rank(Increase) <= $(vTop), Increase)
Hope this will fetch expected results.
Regards!
Rahul
I want those dealers who are consistently growing in all 4 months...firstly this condition apply..n den i want top N Dealers...
For e.g ANJ300736 is growing in all 4 months.
NRM400224 will not come as it falls on 2nd month...
Hope now u understood my issue...
Regards,
Kavita
HI,
Try to create a calculation dimension like below:
step1:
=If(Month<[Month+1] and [Month+1]<[Month+2] and [Month+2] <[Month+3],Dealer)
Step2:
create a variable vTopN and use the same in Dimension Limits
select Show only largest =$(vTopN ) values .
Step3:
Create a Input box and assign this variable and let user to select his choice top value.
Hope this will be helpful else please let me know
Cheers
Hello Kavita,
Replace the Dealer dimension with calculated dimension - =If(Month<=[Month+1] AND [Month+1]<=[Month+2] AND [Month+2]<=[Month+3],Dealer)
Hope this will solve your concern.
Regards!
Rahul
i have an inline field..which has 5,10,15,20 values..which is used for Top N dealers..
I don't want to apply on dimension limit...
I want to write such expression which will give me continuous growth of dealers with top N dealers (On the selection of field).
HI,
If it from a filed then create same variable with expression =Max(Top N)
What will be the problem if you you can use Dimension Limits , any specific reason?If so,
Please do share your app
Stealing ideas from Sasi and Rahul to come up with the attached sample. See if it helps