expression to count number of entries per day

[#1]

Hi,

I have a script that outputs the times an employee swiped per day.

There will be a report that outputs details per day per week.

I am having an issue with writing an expression to count the number of clockings made per particular day.

Using the count function count(fieldname) but Im not sure what to do about the number of entries (clocking times) per user per day? Its the per user per day part that I am struggling with.

Thanks,

Gregg

[CELAMBARASAN]

Hi,

     Have you tried using Count(FieldName&ClockingTimes)

Celambarasan

[#3]

Hi,

I am using COUNT(fieldname) but the clocking times are a time - Im not sure how to count these.

Regards,

Gregg

[CELAMBARASAN]

Hi,

     Sorry Can you tel me little more clear?If possible with some example data.

Celambarasan

[jagan]

Hi,

If you date and Time in the same field, then you can directly get the count by using the expression

=Count(DateFieldName)

If it by day, then use Date(with No Time) as Dimension, if it is by Week then use Week as dimension.

Can you attach sample file.

Regards,

Jagan.

[#6]

Hi,

I have attached sample output.

I need to count the number of Clockings per day (fieldname = Time)

If I use count function it will give me each entry (1)

I need to count them per (NAME) per day (Date)

There can be several swipes (entries) per day.

I am using straight Table.

Hope this is clearer.

Thanks,

Gregg

[CELAMBARASAN]

Hi,

     Have Date,Name as dimension

     Expression: Count(Name&Date&Timings) which will give you the total swipes.

Celambarasan

[jagan]

Hi,

If I understood correctly, you need number of swipes done by person and by date.  If so, then use Date, Name as dimensions, and use the expression below.

=Count(Timings)

The output of the chart would be like this

Date             Person       # of Swipes

1/1/2012    joe bloggs      2

Hope this helps you.

Regards,

Jagan.

[#9]

Hi,

Thanks both for your help.

Both answers work, but I wil need to also display the clockings (TIMES) which is causing my issue I think.

Regards,

Gregg

[CELAMBARASAN]

Hi,

     Then use expression as

     Count(Total<Date,Name> Timings)

Hope it helps

Celambarasan