Count Distinct on a Formula Indicator

[Navya45]

Hi,

I have 3 automated Indicators where I calculate the different review tasks on each of the indicator and I sum all the 3 indicators in a formula indicator. 

Now I would like to count distinct on the formula indicator. Is there a way I can count distinct on a formula indicator?

Example :

I have a change CHG123456 for which the implementation, validation and review tasks are missing.

Indicator 1: Counts all the Implementation task missing changes 

Indicator 2: Counts all the Validation task missing changes 

Indicator 3: Counts all the Review task missing changes 

Formula Indicator: Count Distinct (Indicator 1 + Indicator 2 + Indicator 3)

Is this possible? 

Thanks in Advance!!

[Hasan6]

Hi Navya,

Finding distinct in formula is not possible.

But you can create another automated indicator for it.

Indicator source:

Best

Hasan

[Amit Gujarathi]

HI @Navya45 ,
I trust you are doing great.
Please give a try to the below code :

I have 3 automated Indicators where I calculate the different review tasks on each of the indicator and I sum all the 3 indicators in a formula indicator. 

Now I would like to count distinct on the formula indicator. Is there a way I can count distinct on a formula indicator?

 

Example :

I have a change CHG123456 for which the implementation, validation and review tasks are missing.

Indicator 1: Counts all the Implementation task missing changes 

Indicator 2: Counts all the Validation task missing changes 

Indicator 3: Counts all the Review task missing changes 

 

Formula Indicator: Count Distinct (Indicator 1 + Indicator 2 + Indicator 3)

 

Is this possible?