Set analysis issue

[Anonymous]

Hi,

I have one issue in with this kind of values in set analysis.

=count(DISTINCT{$<[page]={'www:cart:cloud:complete'},[Campaign Channel]={'Direct Load'},[Site Visit Hit Source]=-{5,7,8,9}, [Site Visit Post Page Event] = {0}>} [Visitor ID])

I am getting one value. If i remove [page]={'www:cart:cloud:complete'} this from set analysis there is no change in the result. But if I select this value from list box it is getting change. Is there any way to handle this www:cart:cloud:complete.

Pls help me on this issue.

Regards,

Kumar

[pamaxeed]

you tried using wildcards?

=count(DISTINCT{$<[page]={'*complete'},[Campaign Channel]={'Direct Load'},[Site Visit Hit Source]=-{5,7,8,9}, [Site Visit Post Page Event] = {0}>} [Visitor ID])

[#3]

As suggested by my fellow friends, you must try double quotes or wildcards.

Also, why we are wrapping the "page" column with square brackets? Check if the column from background is coming with brackets or not.

Can you create a sample file and attach for us.

Thanks,

Singh

[Anonymous]

Hi,

Thanks a lot. Instead of capital P, I am using small p.

Regards,

Kumar