Count Rows

[#1]

Hi,

I want to count the specific rows, the records are shown below:

CompletionDate	CountMemberId	DateEntered	MemberId
2010/03/28 22:22:11	16860281	2010/03/24 23:38:31	16860281
2010/04/04 04:08:41	16860281	2010/03/24 23:38:31	16860281
2010/04/04 06:44:44	16860281	2010/03/24 23:38:31	16860281
2010/04/05 02:02:54	16860281	2010/03/24 23:38:31	16860281
2010/04/07 22:27:28	16860281	2010/03/24 23:38:31	16860281
2010/04/11 23:47:06	16860281	2010/03/24 23:38:31	16860281
2010/04/19 23:40:16	16860281	2010/03/24 23:38:31	16860281
2010/04/23 05:43:58	16860281	2010/03/24 23:38:31	16860281
2010/05/05 07:45:40	16742755	2010/03/13 12:56:27	16742755

I want to count the rows whose completionDate<=DateEntered+7(days), and use MemberId as the dimension to show.

How to use set analysis to achieve?

Thanks.

[#2]

When I remove the last row whose memberid is 16742755, then use set analysis:

count({1<CompletionDate={"<=$(=Date((DateEntered+10),'YYYY/MM/DD hh:mm:ss'))"}>}CountMemberId)

It makes sense, but if includes that row, this expression will not work.

[jonathandienst]

Isaac

Please be more specific:

• what did you expect?
• what do you get?

Jonathan

[daveamz]

Hi Isaac,

Try to use a variable as vCheckDate=Date((DateEntered+10),'YYYY/MM/DD hh:mm:ss') then for the set analys formula use:

"count({1<CompletionDate={"<=$(vCheckDate)"}>}CountMemberId)"

Good luck!