Hi Charliy,
I can not use the count formula in the time slot as it does not count all the ID for the day. for example if i had 2 monday in time slot of 6am each of 2 id then the count formual is giving me answer of 2 instead of 4.
hi,
hope some one can help me with this. I have 3 feilds in my table;
EndDate = date field
Time = time field
ID = String field
what i am tring to achive is count for each of the week for last 30 days from the date selected by the user. and then give average for those days based on count of ID...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.