nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Count distinct by id & quarter

Joe Choueiri-Oracle

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.

Find more posts tagged with

Comments

Gianni Ceresa

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

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

Gianni Ceresa

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