"Show Others" and "Show Total" only in bars

[mp802377]

Hello,

I created a couple charts. Based off the slider the user would select 10 or 15 and it would chart the top 10 or top 15. They want another chart that just has the 'Show Others' and 'Show Total'. I had selected both on the 'Dimension Limits tab, but it is still charting the Top 10 (again based on the slider).

This is my first expression:  sum({1<Week = {$(=Week(vLastWeek))} ,Year={$(varYear)}>}realdump+nodump)

And this is my line: sum(realdump+nodump)/Sum(Total realdump+nodump)

The first chart they love. The second (which is pretty much a copy of the first with the addition of Show Others' and 'Show Total'. But they only want to see the Show Others' and 'Show Total'. Is there a way to make that happen?

Thank you,

Martha

[sunny_talwar]

Would you be able to share your app to see how the setup is?

[mp802377]

I cannot because it is confidential data.

realdump and nodump are both numbers. Like realdump might be 25 and nodump might be 100 for one ticket

The dimension is a concatenation of fields:  = pgm & ' - ' & nbr & ' - ' & ticket

This is my first expression:  sum({1<Week = {$(=Week(vLastWeek))} ,Year={$(varYear)}>}realdump+nodump)

And this is my line: sum(realdump+nodump)/Sum(Total realdump+nodump)

[sunny_talwar]

May be this will address your confidentiality concerns

Preparing examples for Upload - Reduction and Data Scrambling

[Sergey_Shuklin]

Hello, Martha!

Istead of usind dimension limits you can use a Rank() function to indicate a number of bars which user wants to see (using slider). It will reduce a headache with visual interpretation:

All values above rank()=slider_value is what user wants to see.

All values below rank()=slider_value is the analogue of "Others"

sum(total) is the Total bar.

Should work.

[mp802377]

I have this setup actually. The slider is setup and the vTop is in the Dimensions Limit tab.

I did find a work around for my problem

Thank you

Martha

[mp802377]

One thing I want to share if anyone else is having the problem is first I removed the dimensions (there should be nothing there) then I did below:

Top Selections:  Sum(Aggr(If(Rank(Sum({$<Week = {$(=Week(vLastWeek))} ,Year={$(varYear)}>} my_calc)) <= vTop, Sum({$<Week = {$(=Week(vLastWeek))} ,Year={$(varYear)}>} my_calc), 0), type))

and my total (since I couldn't use the 'Dimension Limits'

Total:  sum({$<Week = {$(=Week(vLastWeek))} ,Year={$(varYear)}>} my_calc)