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

[sunny_talwar]

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

[Anonymous]

I am converting using date([Time Full Date],'MM/DD/YYYY')

[Anonymous]

Sorry Gabriel, I am getting u what u r saying. Can u explain.

[Anonymous]

still you need to split or you can use floor function as shown by sunny

[settu_periasamy]

It would be easy, if you Post the sample data

[Anonymous]

Hi,

I am attaching sample excel files.

Dim_visitor:

LOAD visitor_key as site_visit_visitor_key

Dim_time:

LOAD time_key as site_visit_start_datetime_key

highlighted keys are coming fact_site_visit table

Regards,

Kumar

[Anonymous]

No use Sunny. I attached sample data, can u look into that one

[Anonymous]

Hi,

Try  this.

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

[settu_periasamy]

Hi,

is it possible to provide to sample qvw?

for clarification, The  field time_full_date in the dim_time.xlsx, shows only 1900 Year data. is this sample purpose?

can you check your original data? The other excel file Date Fields shows 2014 data.

[petter]

The dates in the dim_time.xlsx are not within the same range as the dates in the Fact_site_visit1.xlsx...

So could you verify the data quality here? Keys between these two tables will never return anything however you write your expressions.