Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share your app to see how the setup is?
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)
May be this will address your confidentiality concerns
Preparing examples for Upload - Reduction and Data Scrambling
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.
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
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)