Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE count

mmajdana1

Hi i am using OBIEE 1c

What i want to know is is there a possibility to count different unuque values in the table.

For example i want to count something like this

ID Decision id

100 1

100 2

101 1

100 1

So i want to count how many unique combinations od ID and Decision ID are there

Best regards Matija...

Find more posts tagged with

Accepted answers

All comments

Martin van Donselaar

Count(Distinct ) will do that. Either set it as aggregation rule or use it in the formula depending on your exact requirement

Martin van Donselaar

If you want to count the unique conbinations then you should do something like count(distinct concat(Concat("ID",'~'),"Decision ID"))

The ~ is use as a separator to make sure that for instance 10 and 11 are not counted as the same as 101 and 1

EDIT: If the ID's are numbers then use Cast as Char to convert them to chars

SonPat99

If you can display both ID, Decision_ID column, then you can have a ID, Decision_ID and COUNT(*) because group by will be applied on ID and Decision_ID, giving you distinct combinations.

Obviously a shorter format will be Count Distinct in RPD Aggregation or CountDistinct in Analysis (please note the presence of SPACE in RPD formula)

Martin van Donselaar

Yes that is correct, I was thinking too complicated

Gianni Ceresa

Martin van Donselaar wrote:Yes that is correct, I was thinking too complicated

Or thinking right when other columns get in the analysis (or the 2 mentioned aren't there). Never ever imagine the OP will do just what he asked for on the thread

Martin van Donselaar

Yes it depends on the exact requirement. At least the OP now has multiple solutions to choose from :-)

SonPat99

Seems like he is very famous....