Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to create a calculation like "Number of rows"

Received Response
21
Views
3
Comments
John305
John305 Rank 5 - Community Champion
edited Aug 13, 2024 6:07PM in Oracle Analytics Forum

Hi everyone ,

i wanna create a mesure in "Oracle Administration tool"  , this mesure should give me "1" in each row => so i can use it in my report to have the sum( number of rows ) .

but in my report when i drag and drop the new calculation , all i have is rows of 1 ( not the sum ) , if you have any idea about how to do it . thank you

pastedImage_0.pngpastedImage_1.png

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics & AI Lead

    Do you mean?

    Screen Shot 2017-02-13 at 10.15.04 AM.png

    Screen Shot 2017-02-13 at 10.13.59 AM.png

    Screen Shot 2017-02-13 at 10.13.54 AM.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    For that you generally set a count (or count distinct) aggregation on the ID (PK) column of your data. Don't you have an ID or don't you want to use it?

    You can also try by creating a column as "derived from physical mapping" and in the formula of the column you set 1, you then add an aggreation of SUM on it.

  • John305
    John305 Rank 5 - Community Champion

    Thank you ! i did it and it works !