Re: Trend Analysis.

From: Bill (bill_at_bill.com)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 14:16:28 -0000

I don't really mind. It could be be on a daily, weekly, monthly basis
really. I just want some sort of idea of how many calls were open on (say)
the Monday of each week. Use 8:00 am, or any other time (or day) if it
helps. This is intended to be an overall view of the number of 'open' calls
over a period of time. By open it means that, for the callog itself, an open
date exists, but a closed date does not.

Regarding the count for each member of staff, that may be something I have
to develop having (hopefully) learnt from the answer to the first question.
In fact the calllog is in a 'callog' table, wheras the technician is in an
'assignment' table, making things a little different for that side of my
question!! Help with the first issue would be much appreciated though.

Thanks for your reply.

Regards.
Roger.

"ChrisJ" <ChrisJ@discussions.microsoft.com> wrote in message
news:8037E3ED-AE16-47C6-8DF3-D4510C1E32CC@microsoft.com...
> Bill,
> To clarify your request, does "open at the start of the week" mean
something
> like "open at 8.00 am Monday", or "open before Monday and closed Monday or
> later"
> Then presumably you are looking for weekly counts by "member of staff"
> Does it matter if the log entry was opened and closed by different
members,
> or are these always the same?
>
> Once these are defined, and the names of the fields are known we should be
> able to offer more advice
>
> Chris
> "Bill" wrote:
>
> > At least I think that is what it is!!
> >
> > I need to do a retrospective analysis of the number of Helpdesk Calllogs
> > that were open at the start of the week over the last few years. We have
the
> > [open date] and the [closed date]. There are about 80,000 records. As
well
> > as analysing the overall figure I would also like to do an analysis for
each
> > member of staff.
> >
> > I have to admit that I am struggling to make a start on this. I have a
few
> > ideas, but in the past I have made this sort of thing into hard work,
> > whereas you guys have come with a straightforward solution
> >
> > Any suggestions please?
> >
> > Also can anyone suggest any good books that will help me with how to do
this
> > sort of more complex analysis - at least it is to me!
> >
> > Many thanks.
> > Bill.
> >
> >
> >

Relevant Pages

  • RE: Trend Analysis.
    ... Then presumably you are looking for weekly counts by "member of staff" ... "Bill" wrote: ... > ideas, but in the past I have made this sort of thing into hard work, ...
    (microsoft.public.access.queries)
  • Re: Survey: CAD Posts.
    ... explaining what separates UG NX CAM from say Mastercam. ... Bill just started a new job. ... NX CAM Operation Manager is radically better than the approach ... You can sort the operations list with a simple right click. ...
    (alt.machines.cnc)
  • Re: Phone latest... was Weighing the merits of Obama
    ... We *still* have not been able to return the mobile phone that has never ... Incidentily the bill is nearly twice what it should be too. ... I wrote to their complaints department telling them that we had ... solicitor if they didn't sort it out NOW! ...
    (soc.culture.scottish)
  • Re: Mergesort Vs Quicksort
    ... Though in terms of average and best case complexity, both merge sort ... Any thoughts on why quicksort is preferred over merge sort. ... "Pick an arbitrary member of a data set, put all lesser members to its left ...
    (comp.programming)
  • Re: How could I have lived so long without XM Radio?
    ... some sort of IC. ... each thought the other was a member. ... "regulars", some of whom have met in person, and many who haven't. ... folks in this newsgroup tend to treat each other as real ...
    (rec.music.makers.guitar.acoustic)