1 2 Previous Next 22 Replies Latest reply on Nov 12, 2018 12:41 AM by sravani adapa

Different Rank Ranges finding top.....

Hi guys,

i am face challenging on Rank based different ranges analysis.Please any one solve this problem.Rank should be based on Deposits.can use superstore data set.Deposits(Sales).

Thanks,

Sravani

• 1. Re: Different Rank Ranges finding top.....

Hi Sravani,

If you need to create a rank based off of Total Deposits then the calculation is simply:

rank{[Total Deposits]).

Since this is a table calculation, after you put this rank field onto your viz, right click it and select Edit Table Calculation.  You can then select which field(s) you'd like the rank calculated across.

Best,

Paul

• 2. Re: Different Rank Ranges finding top.....

Good morning

Please attach your twbx workbook even with some dummy data included to show us how far you got and where you are stuck

Thanks

Jim

• 3. Re: Different Rank Ranges finding top.....

Hello Sravani,

I am not sure I understood your requirement or not. Here I have crated a sales bin with bin size of 100. The viz tells that how many customers are there with with in the bin size. Refer the attached.

Please attach some sample data and expected result.

S

• 4. Re: Different Rank Ranges finding top.....

Thanks sudheer,

but the requirement is different ranges like TOP50,TOP51-100,TOP101-500,TOP501-1000,TOP1001-5000,TOP5001-10000,TOP10001-20000,Others.

Bin accepts single range.i faced the problem in different ranges like above mentioned.

Thanks,

Sravani

• 5. Re: Different Rank Ranges finding top.....

thanks Paul,But the problem is how to show the ranges.actually i created Rank(sum(Deposit)).then i created Ranges calculated field liike

if rank<=50 then "TOP50"

elseif rank<=100 and rank>=51 then "TOP51-100"

elseif rank<=500 and rank>=101 then "TOP101-500"

elseif rank<=1000 and rank>=501 then "TOP501-1000"

elseif rank<=5000 and rank>=1001 then "TOP1001-5000"

elseif rank<=10000 and rank>=5001 then "TOP5001-10000"

elseif rank<=20000 and rank>=10001 then "TOP10001-20000"

else "Others"

end

but his is not giving the result.

Thanks,

Sravani

• 6. Re: Different Rank Ranges finding top.....

Hello Sravani,

Please check the below, you may get some idea:

Calculation 1: RANK(SUM([Sales]))

Calculation 2: IF [Calculation1] <= 50 THEN 'Top 50' ELSE 'Others' END

S

• 7. Re: Different Rank Ranges finding top.....

If you're creating bins based on Sales Rank, then Top 50 Customers/Users Count will always be 50 , Top 51-100 count will always be 50, Top 101-500 will always be 400 and so on. I don't see any range analysis in this approach because the count will always remain same as long as Sum(sales) for each customer is unique value. There will be some difference in count when two or more customers have same sales amount.

• 8. Re: Different Rank Ranges finding top.....

i am trying to showing above analysis,not for customer wise.

Thanks,

Sravani

• 9. Re: Different Rank Ranges finding top.....

the main thing is how to create Bin with different ranges.

Thanks,

Sravani

• 10. Re: Different Rank Ranges finding top.....

I've created a dummy data of Student and Marks. Are you looking for something like this ?

• 11. Re: Different Rank Ranges finding top.....

thanks Ombir,but the range is different like TOP50,TOP51-100,TOP101-500,TOP501-1000,others.please attach the workbook.

Thanks,

Sravani

• 12. Re: Different Rank Ranges finding top.....

Workbook is already attached. I made this with dummy data. You can modify the calculation as per your requirement.

• 13. Re: Different Rank Ranges finding top.....

i didn't get the attached Twbx.Please attach the twbx.

Thanks,

Sravani

• 14. Re: Different Rank Ranges finding top.....

Its already attached in above message. Attaching again.

1 2 Previous Next