Rows overcounting in Analysis
Summary
How to only count the number of rows showing in an analysisContent
Hello Oracle communities,
When I attempt to display the total number of rows shown in an analysis in BI, and it resulted in the number of rows counted (12636) being beyond the number of rows displayed (2) per enclosed screenshot. This over counting happens with both count() and sum() functions. The "Orders" column, data be counted, is a fact component.
I also tried running count() on the "Order" column, a dimension column showing the number ID of an order. "1" showed up per each row under that new calculated column.
1