Skip to Content
avatar image
Former Member

Complex Ranking/Top N% problem

I have a fairly complex scenario that we need to present on a dashboard.

We need to be able to visualize the following. The data will be sourced from a BEx query, where we will have a vendor and spend available. My first challenge is getting the spend broken down into top 5%/Other. Making it even more unique is that the definition of top 5% is based on vendor count, not by spend. So using a top N condition in a reference query won't help (I don't think).

The sample data below highlights what we're trying to accomplish.

I'm looking for options here to be able to deliver the above result. We have the ability to create one or more BEx queries if that would help.

Some options we've considered:

1. Create a custom datasource and derive the values in script.

2. I don't think that Former Member Former Membertopics on this will satisfy the requirement because of the complex way that we want to derive top N.

I'm still new to design studio, so I may be overcomplicating this. Ideally we'd be able to change the data in the datasource (we could include some dummy KF's in a BEx query), so that way we could bind that data to any control, but I'm not completely tied to that. I'm looking to understand how others might approach this in terms of visualization. For example, can we create a table control and populate that via script without modifying the datasource contents (which I don't think I can do).

Feel free to point me to similar links to review (although I promise, I have searched 😊

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 13, 2016 at 05:52 PM

    Hi Richard,

    did you try:

    - first create a Local Calculation in the BEx query which would be either a Rank or an Olympic Rank based on the Spend

    - Then setup a condition based on that local calculation ?


    Ingo Hilgefort

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2016 at 05:28 PM

    Hello Richard,

    I'm not following the vendor count; it is the # of times you have done business with a vendor or?

    Is the count in your BEx query too?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      In the above example, I used 15 vendors (probably should have been more creative with my vendor #). 5% of 15, rounded up, is 1. So, In this case we're looking for vendors ranked 1 or lower by spend in the top 5%. If for example, vendor 2 had a spend of 9999, it wouldn't show up in the results, because it would have been ranked 2.

      Did that clarify your question?

  • avatar image
    Former Member
    Apr 13, 2016 at 05:43 PM

    I should add that I haven't ruled out the custom datasource option, but I'd rather avoid the custom extension at this point if possible, solely due to the dynamics of this client. I may very well present it if folks think that's the ideal way to go.

    Ideally, we'd use standard controls with some script to accomplish the result, but I will propose this option too.

    Add comment
    10|10000 characters needed characters exceeded