topic Re: Set Analysis in App Development

Set Analysis

Anonymous — Thu, 02 Nov 2017 13:51:48 GMT

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?

Re: Set Analysis

Anonymous — Thu, 02 Nov 2017 14:00:03 GMT

All good apart from DISTINCT rather than Distincts

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

Re: Set Analysis

Anonymous — Thu, 02 Nov 2017 14:01:04 GMT

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

Re: Set Analysis

shanky1907 — Thu, 02 Nov 2017 14:01:11 GMT

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

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

Re: Set Analysis

shanky1907 — Thu, 02 Nov 2017 14:01:54 GMT

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

Re: Set Analysis

shanky1907 — Thu, 02 Nov 2017 14:02:24 GMT

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

Re: Set Analysis

Anonymous — Thu, 02 Nov 2017 14:03:28 GMT

it's the same?

Re: Set Analysis

shanky1907 — Thu, 02 Nov 2017 14:05:58 GMT

What conditions you want to add?

Re: Set Analysis

Anonymous — Thu, 02 Nov 2017 14:09:24 GMT

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

Re: Set Analysis

shanky1907 — Thu, 02 Nov 2017 14:11:15 GMT

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)

Re: Set Analysis

Anonymous — Thu, 02 Nov 2017 14:14:01 GMT

You are right!
I just wanted to know if what I thought was correct.

Thank you for your help.

Re: Set Analysis

shanky1907 — Thu, 02 Nov 2017 14:14:44 GMT

Please mark my reply as Correct if you like and close the thread. Thanks