Need help in expression

[Anonymous]

Hi,

I had written one expression, but it is showing invalid data. in expression it is ok, but some where it is going wrong.

Pls see the screen shot and help me on this.

Regards,

Kumar

[Anonymous]

Hi Sunny,

As u suggested i tried, but still i am able to see 0's only.

[Anonymous]

Hi Manjunath,

I included variables and tried, but no use.

[sunny_talwar]

Did you try this one?

=Count(DISTINCT{$<[Site Visit Hit Source] -= {'5', '7' ,'8' ,'9'}, [Site Visit Post Page Event] = {0},[Time Full Date]={"$(=Date(Max([Time Full Date]) - 30,'MM/DD/YYYY'))"}>} [Visitor ID])

Is Time Full Date a date field or TimeStamp field?? If it is TimeStamp then your expression will most likely not going to work.

[Anonymous]

I would step by step

provide an expression just with "sum([Visitor ID), any results?

next provide listbox with [Site Visit Hit Source] and select all values other than 5,7,8,9

next provide listbox with [Site Visit Post Page Event] and select 0, any results

finally provide listbox with ([Time Full Date]) and select last 30 days

if you still get a result, then search for error in expression

if you didnot get a result, than check your data

[jonathandienst]

jontydkpi wrote:

     [Site Visit Hit Source] -= {5, 7, 8, 9}, ....

I have already given you the  answer, did you try this?

[Anonymous]

Yes, it is time stamp only. Do we have any alternate solution to achieve this one.

[Anonymous]

data is there.

[Anonymous]

Hi Jonathan,,

I tried already, but it not working.

[Anonymous]

hi,

please split timestamp field to date and time fields and use date field in expression

[Gabriel]

Hi,

Your DISTINCT should be before [Visitor ID]