Top dealers and consistent growth...

[kavita25]

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

stalwar1‌ gwassenaar‌ swuehl‌

PFA qvw and data..

[sunny_talwar]

You want to see top 5 based on Increase column?

[kavita25]

Firstly I want those dealers only...who are consitently growing in 4 months...

After that I want to apply...Top N Dealers.

Regards,

Kavita

[rahulpawarb]

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

[kavita25]

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

[sasikanth]

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

[rahulpawarb]

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

[kavita25]

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

[sasikanth]

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

[sunny_talwar]

Stealing ideas from Sasi and Rahul to come up with the attached sample. See if it helps