Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
yes its correct ...
//one extra comma(,) not required
count(DISTINCT {$<Name={'Rexona'}>}%Product) = Should give me the distinct count of Product only for rexona ,
yes its correct ...
//one extra comma(,) not required
count(DISTINCT {$<Name={'Rexona'}>}%Product) = Should give me the distinct count of Product only for rexona ,
Comma must be deleted ...
from
count(DISTINCT {$<Name={'Rexona',}>}%Product)
to
count(DISTINCT {$<Name={'Rexona'}>}%Product)
count(DISTINCT {$<Name={'Rexona',}>}%Product)
You have extra , here.... remove it..
Correct.
count(DISTINCT {$<Name={'Rexona'}>}%Product)
Second one is right.
Regards,
Kaushik Solanki
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])
This below -
{'Rexona','Lux'}
is interpreted as Rexona OR Lux so both will be considered.