Grouping In OBIEE — Oracle Analytics

Oracle Analytics Cloud and Server

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

Grouping In OBIEE

Received Response
11
Views
2
Comments
3184221
3184221 Rank 3 - Community Apprentice

Hello All,

I have a requirement they want to see count of the columns.I am facing a issue to do it. Can anyone let me know how to do this requirement.

Sample Data:-

   

Status 2015Status 2016Status 2017
Service PartSerial PartTBD
Service PartSerial PartTBD
Service PartSerial PartService Part
Service PartSerial PartSerial Part
TBDService PartSerial Part

Note :-Data above is conditional data and there is no unique column i can group by

Expected Data:-                     

             Status 2015Status 2016Status 2017
Service Part411
Serial Part042
TBD100

Let me know your thoughts

Thanks

Uday

Answers

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    In column formula add something like Count("Column Name" by "Column Name")  and also add the column. Then use pivot table. Example...

    pastedImage_1.png

    pastedImage_2.png

  • 3184221
    3184221 Rank 3 - Community Apprentice

    Thanks Its is working