Set Analysis

[smilingjohn]

HI All please find the below set analysis code and please let me know if it is correct

1. count(DISTINCT {$<Name={'Rexona',}>}%Product)   = Should give me the distinct count of Product only for rexona ,

2.count(DISTINCT {$<DRGRSLT={'Rexona','Lux'}>}%IncidentKey)   = should give me the  disticnt count of Rexona plus Lux

[avinashelite · Accepted solution]

yes its correct ...

//one extra comma(,) not required

count(DISTINCT {$<Name={'Rexona'}>}%Product)   = Should give me the distinct count of Product only for rexona ,

[alexandros17]

Comma must be deleted ...

from

count(DISTINCT {$<Name={'Rexona',}>}%Product)

to

count(DISTINCT {$<Name={'Rexona'}>}%Product)

[kaushiknsolanki]

count(DISTINCT {$<Name={'Rexona',}>}%Product)

You have extra , here.... remove it..

Correct.

count(DISTINCT {$<Name={'Rexona'}>}%Product)

Second one is right.

Regards,

Kaushik Solanki

[sunny_talwar]

1st looks right, but just remove the comma after 'Rexona'

Count(DISTINCT {$<Name={'Rexona'}>} [%Product])

2nd one is using DRGRSLT and 1st expression using Name. Should both of them be using the same field name?

Count(DISTINCT {$<DRGRSLT={'Rexona', 'Lux'}>} [%IncidentKey])

[Digvijay_Singh]

This below -

{'Rexona','Lux'}

is interpreted as Rexona OR Lux so both will be considered.