3 Replies Latest reply: Jul 8, 2013 3:31 PM by Gysbert Wassenaar RSS

    Chart Dimension Limits Others Option

      Hello Community,

       

      I am trying to use the dimension limits to bring in the top 25 ranked groups by transaction count. I am using the RANK function in my expression and in addition to the top 25, I want to show all others. I'm using the "Others" options on the dimension limits tab to do this.

       

       

      My problem is this; the "others" is being ranked in the chart thus throwing my ranking off by 1 which isn't going to work for me.

       

      Has anyone else run into this issue and if so, what was your workaround?

       

      For context purposes, I don't want to use a calculated dimension since I'll take a performance hit and I don't want to code this into my expression since an "if statement" will be heavy.

       

      I thank you in advance for your expertise.