How to create a calculation like "Number of rows" — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

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
11
Views
3
Comments
John305
John305 Rank 5 - Community Champion
edited Aug 13, 2024 6:07PM in Oracle Analytics Cloud and Server

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 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 !