Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Bin Drill - Data not matching
Answers
-
It is aggregated value for Code level
0 -
You have same totals ... but your detail rows don't fit the bin (as you've presented them) ... or are you saying that the 4th row: 10,651 is an aggregation of multiple deals all withing 1000-10000? if so, that's very confusing to someone who is struggling with an issue. Show them the end result - EACH detail row that proves the drilling on bin works.
0 -
It had 400 records..
0 -
+1 unless in some weird mathematics universe 52'000 and 18'000 are below 10'000
0 -
Yeah well your screenshot above still nicely shows 5 rows with values > 10'000
0 -
Nopes.. The second report i had an aggregation for Code column. If i remove it will not have any records over 10000. Can you please check in your environment? isnt it working in your BI system?
0 -
Ok so just add the "Filters" view to your second (target) analysis and show us how the filter effectively gets applied!
h/t @Thomas Dodds
0 -
0
