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

Count distinct by id & quarter

22
Views
3
Comments
Joe Choueiri-Oracle
Joe Choueiri-Oracle Rank 5 - Community Champion
edited August 2024 in Oracle Analytics Cloud and Server

Hi

OBIEE 12C/Answers

I have this table below, showing oppty number by snap fiscal qtr and snap fiscal week but then the same oppty id keeps appearing week over week, but I am wondering if either I show it only once and it will be counted once or show it every week for given quarter but then count it only once...any idea? and if we were able to get a solution for this challenge, I need to delete the oppty number, snap date, and see the aggregated number without counting the duplicate. thanks so much.



Comments

  • Gianni Ceresa
    Gianni Ceresa Mod

    Set your measure as a COUNT DISTINCT aggregation in the RPD and job done, no?

    Even if you display it multiple times because that's the reality (the same number exist in multiple dates or weeks), the totals for higher levels will do a count distinct and will work just well.

  • Joe Choueiri-Oracle
    Joe Choueiri-Oracle Rank 5 - Community Champion

    Thanks Gianni for taking the time, I personally dont have access to the RPD.

  • Gianni Ceresa
    Gianni Ceresa Mod

    And if you change the aggregation to count distinct in the front-end? Or create a new calculated column in the analysis?