Set Analysis

[Anonymous]

Hello,

I would like a confirmation for the sets analysis.

Count ({$ <date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}>} Distincts card_number)

This Set analysis  count the number of card_number_dwhen the date_ctrl_court = {'26/09/2017'} and the status is sent?

[Anonymous · Accepted solution]

All good apart from DISTINCT rather than Distincts

Count ({$ <date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}>} Distinct card_number)

[Anonymous]

Thank you
So if I want to add filters just add the other fields?

[shanky1907]

Count ({$ <date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}>} Distinct card_number)

or

Count ({<date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}>} Distincts card_number)

[shanky1907]

Yes you can the same way. So count will be taken filtered out on all conditions

[shanky1907]

Count ({<date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}>} Distinct card_number)

[Anonymous]

it's the same?

[shanky1907]

What conditions you want to add?

[Anonymous]

Like if date_fin={'26/30/2017'},

[shanky1907]

I assume the Date is not in correct format. lets take it as 26/10/2017 then

Count ({<date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}, date_fin={'26/10/2017'}>} Distinct card_number)