Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this in back end.
Data:
LOAD *,Date(Floor(TimeData)) as Date,
[Employee id]&'-'&Date(Floor(TimeData))as Employee_id,
Time(Frac(TimeData)) as Time ;
LOAD id,
[Employee id],
EventID,
TimeData
FROM
(ooxml, embedded labels, table is Sheet1);
By this you are creating Employee id & Date combo.
So, in front end use Count(Distinct Employee_id). You will get 3.
Hi,
Try count(Distinct [employee id])
Regards,
jagan.
Try this expression
=Sum(Aggr(Count(Distinct [employee id]), Date)
Hope this helps you.
Regards,
Jagan.
i am going to use count(employee id ) in many situations so is their any way to make changes in background
By using this i am not getting the correct results
=Sum(Aggr(Count(Distinct [employee id]), Date))
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
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
also have a look on the post by me with name How to get correct total
for this also i didn't received answer
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.
i want to use time column in coming scripts