Why are there 3 different Top Counts?

This topic contains 0 replies, has 1 voice, and was last updated by  Frank 3 months, 3 weeks ago.

  • Author
    Posts
  • #590
     Frank 
    Keymaster
    • Topics Started - 64
    • Replies Written - 52

    When you filter a measure in Stratum there are 3 different types of Top counts – what are they and why have them?

    Good questions we got from a customer. BTW if you didn’t get our survey on our education let us know at info@silvon.com and we’ll send a link so we can get your feedback. If you did get the survey and respond thanks! If you didn’t respond please consider it – we use this input to build classes, posts and videos.

    So…on to top counts. I’m going to focus on top counts, but all the same ideas apply to bottom counts. In general folks use top counts for a couple of reasons. One to see what are the best performing things across a set of criteria and two to focus on those things that are having the biggest impact on the business.

    Over the years we expanded our top count options based on feedback from customers. Stratum offers 3 different top counts:
    1. Top Count
    2. Recursive Top Count
    3. Overall Top Count

    These options can be found in the Data tab of the filter window – accessed by clicking on the funnel icon at the top of the window in a view or by right clicking the column header for a measure (like Sales Amount, Units, Costs etc.) and selecting filter.

    There is pretty good Stratum help on these here.

    So for an example lets say we are looking at a view by Division|Brand|Product|SalesPerson and the YTD Sales.
    If we apply the different top count filters to our YTD Sales column looking for the top 5 we would get the following results (lets assume we drill on the headers when we drill):

    1. Top Count – applied at the last level drilled to
    * So if you started at Division you’d see the Top 5 divisions
    * Drill to Brand – you’ll get the top 5 Brands for each division
    * Drill to Product and you’ll get the top 5 products for each Div|Brand combination
    * Drill to SalesPerson you’ll get the top 5 SalePerson for each Div|Brand|Product combination.
    As you can see using the Top Count only the last dimension you drill to is filtered by the Top Count

    2. Recursive Top Count – applies the count to each dimension you drill to
    * So if you started at Division you’d see the Top 5 divisions
    * Drill to Brand – you’ll get the top 5 Divisions and within those you’ll get the top 5 brands
    * Drill to Product and you’ll get the top 5 Divisions and within those you’ll get the top 5 brands and within those the top 5 Products
    * Drill to SalesPerson you’ll get top 5 Divisions and within those you’ll get the top 5 brands and within those the top 5 Products and finally the top 5 salespeople within those
    As you can see using the Recursive Top Count applies the top count to each level you drill thru.

    3. Overall Top Count – Applied to all of the data you are looking at – you’ll get the top 5 combo’s of data
    * So if you started at Division you’d see the Top 5 divisions
    * Drill to Brand – you’ll get the top 5 Div|Brand combinations
    * Drill to Product and you’ll get the top 5 Div|Brand|Product combinations
    * Drill to SalesPerson you’ll get the top 5 Div|Brand|Product|SalePerson combinations
    As you can see using the Overall Top Count you will wind up with the top x combonations across everything you are looking at.

    All this holds true for bottom counts as well. check out the Help link above for more details and examples. (ok maybe not more detail, but way better examples).

You must be logged in to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

©2020 KLEO Template a premium and multipurpose theme from Seventh Queen

Log in with your credentials

or    

Forgot your details?