How to get correct employee count datewise

[#1]

Hi All

PFA

here by using below script

Data:

LOAD *,Date(Floor(TimeData)) as Date,

       Time(Frac(TimeData)) as Time  ;

LOAD id,

     [Employee id],

     EventID,

     TimeData

FROM

(ooxml, embedded labels, table is Sheet1);

and in text object expression count(employee id) it is giving 30

i want count as 3 here only 3 dates are available

how to get this please reply me

Regards

Hemesh

[#2]

it is working fine please find the qvw that i attached here while using join with manager details table i am not getting matching records from manager table

[nagarjuna_kotha]

Well,

If you check the field Employee_id That is Concatenated with date also.the Employ Id should change right?.

If you take that Employee_id in tables like Straight Table, Pivot Table and TableBox ,You can see the difference.

Regards,

Nagarjuna

[#4]

my previous expression is count(employee id) i replaced it  with sum(aggr(count(employee id),employee id ,date))

how can i replaced  the expression of

=Concat(if(aggr(rank(count({<HourFLag={'Violation'}>}[Employee id])),[Employee id])<=3,[Employee id]),Chr(13))