Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
=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,
It does not work
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
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,
Check date format also is it matching with Sale_Date??
Regards,
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
The date is in the same format, you can see in the picture I have attached
That's what I see
Start and end date are the same exact timestamps... do you have something that precise in your data?