Hi Folks,
I'm working to create a set of the top 10 by a measure. However, for some reason the set isn't including everything an item that should be included in the top 10. As can be seen in the screenshots below. The item "out" of the set clearly is higher than the last item "in" the set but it is not being included "in". Why is this happening?
Thanks,
Torey
I think the key is what dimension is the set based off of? You have several dimensions in the view.
The set is based off of the ID. So Top 10 IDs based on C. AUM.
Hey Torey,
What is the Field/ Dimension on which the 'Set' has been created? If the intention is to display top 10 by Product Names, then the SET must be defined over Product Name. Hope that would resolve the problem.
The Set is based on the ID dimension. Which is just a combination of Firm Name and Product Name.
Do you have any filters in your view - such as a date filter? If so, have you tried setting it to a context filter?
John,
Could you please explain the logic behind this so I can understand going forward?
Thank you!
The simplest way to think of it is that the query going to the data source queries ALL records independent of filters. Setting filters to context will only use the relevant filtered records.
Torey, Sure. Can you mark this thread as correct to close it? Thanks.