6 Replies Latest reply: Jun 29, 2017 2:04 PM by Martha Parsons

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

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

• ###### Re: "Show Others" and "Show Total" only in bars

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

• ###### Re: "Show Others" and "Show Total" only in bars

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)

• ###### Re: "Show Others" and "Show Total" only in bars

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.

• ###### Re: "Show Others" and "Show Total" only in bars

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

• ###### Re: "Show Others" and "Show Total" only in bars

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)