Problem with set analysis

[ttal7878]

Hi,

Can anyone explain,  why the information is not displayed in table "Display Unique"?

I have an ID that meets all the conditions I defined in my set Analytics and is not yet displayed in the table "Display Unique".

It's problematic for me to upload my real model,

and I can't imitate the problem in an example model, So I'll try to explain with picture from my model.

I have a table "Display Unique" which counts the unique's according to the following parameters:

Lead_In_TMS={"Yes"},

ActionTypeName={"Lead"},

Source={"Online"}

Sale_Date={">=$(VMinDateIgnoreActionLeadTMSSource)<=$(VMaxDateIgnoreActionLeadTMSSource)"}>}

and ignore the following parameters:

Lead_In_TMS=

ActionTypeName=

Source=

The variables are calculated as follows:

VMinDateIgnoreActionLeadTMSSource=

=Timestamp(min({<ActionTypeName=,Lead_In_TMS=,Source=>}Sale_Date),'YYYY-MM-DD hh:mm')

VMaxDateIgnoreActionLeadTMSSource=

=Timestamp(max({<ActionTypeName=,Lead_In_TMS=,Source=>}Sale_Date),'YYYY-MM-DD hh:mm')

I'am using the following Set Analysis to count the unique's:

=count(DISTINCT {<ActionTypeName=,Lead_In_TMS=,Source=,

Lead_In_TMS={"Yes"},ActionTypeName={"Lead"},Source={"Online"},

Sale_Date={">=$(VMinDateIgnoreActionLeadTMSSource)<=$(VMaxDateIgnoreActionLeadTMSSource)"}>}

Unique)

What do I miss?

[PrashantSangle]

=count(DISTINCT {<ActionTypeName=,Lead_In_TMS=,Source=,

Lead_In_TMS={"Yes"},ActionTypeName={"Lead"},Source={"Online"},

Sale_Date={">=$(=VMinDateIgnoreActionLeadTMSSource)<=$(=VMaxDateIgnoreActionLeadTMSSource)"}>}

Unique)

Write = before variable Name in set anlaysis

Regards,

[ttal7878]

It does not work

[sunny_talwar]

Do you get a result without the set analysis on date

=count(DISTINCT {<ActionTypeName=,Lead_In_TMS=,Source=,

Lead_In_TMS={"Yes"},ActionTypeName={"Lead"},Source={"Online"}>}

Unique)

Also, do you get a result with just the set analysis on date?

=count(DISTINCT {<Sale_Date={">=$(=VMinDateIgnoreActionLeadTMSSource)<=$(=VMaxDateIgnoreActionLeadTMSSource)"}>} Unique)

Just trying to figure out if the issue is in the date part of the expression or something else

[PrashantSangle]

Hi,

debug your expression,

take straight table

use sale_date as dimension

in expression write above expression.

then move your arrow on straight table header and check your expression is evaluating what value.

Regards,

[PrashantSangle]

Check date format also is it matching with Sale_Date??

Regards,

[ttal7878]

yes,I'm getting  the result without the set analysis on date.

and

I'm not getting the result with just the set analysis on date

[ttal7878]

The date is in the same format, you can see in the picture I have attached

[ttal7878]

That's what I see

[sunny_talwar]

Start and end date are the same exact timestamps... do you have something that precise in your data?