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

[jagan]

Hi,

Try count(Distinct [employee id])

Regards,

jagan.

[jagan]

Try this expression

=Sum(Aggr(Count(Distinct [employee id]), Date)

Hope this helps you.

Regards,

Jagan.

[#4]

i am going to use count(employee id ) in many situations so is their any way to make changes in background

[#5]

By using this  i am not getting the correct results

=Sum(Aggr(Count(Distinct [employee id]), Date))

[#6]

i have to get count as 3 i.e. here 3 dates are available

only one employee for one date

by removing floor it will show count as 30

[HirisH_V7]

Hi,

You can get the count of date with respect to emp.id Like this,

=Aggr(Count(Distinct Date),[Employee id])

PFA.

Hope this helps,

Regards,

Hirish

[#8]

also have a look on  the post by me with name How to get correct total

for this also i didn't received answer

[jagan]

Hi,

If you are not using time remove that column and use Distinct  in the load statement like below.

Data:

LOAD DISTINCT

id,

     [Employee id],

     EventID,

Date(Floor(TimeData)) as Date;

LOAD id,

     [Employee id],

     EventID,

     TimeData

FROM

(ooxml, embedded labels, table is Sheet1);

Hope this helps you.

Regards,

Jagan.

[#10]

i want to use time column in coming scripts