Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Selection Step returning wrong results
I have 4 columns in a report:
Agent ID
Dist ID
Activations
Rank
*note - the above 'Rank' column used the RANK function: Rank(Activations)
In my report, I only want to show the Agents with the top 25 in 'Activations'.
I set up a selection step on Agent ID to keep only members of Agent ID where Rank <= 25
This seems to work pretty well EXCEPT it returns one row where RANK is 86 and Sales = 0
I cannot seem to get the selection step to not return that last row where Sale = 0.
Any thoughts on why this member with a rank of 86 would be displaying?
Message was edited by: CArnold40 Corrected typo -- changed 'Rank>=25' to correctly show 'Rank<=25'
Answers
-
Your Rank() ... are you ranking BY anything? going to try to recreate something similar ...
On second thought if you only want the top 25 Ranked Agent IDs (independent of Dist ID) then apply a filter in Criteria tab to the rank(activations) to be less than or equal to 25 ...
0 -
Yes, thank you. I just went ahead & did what you were suggesting & created a filter in the criteria. It worked.
I'm still left wondering why the 'Selection Step' method was returning that one 'rank 86' row. It just makes no sense to me.
Oh well...I may be left to always wonder...but at least my report is built!
Thanks again.
0