/build/static/layout/Breadcrumb_cap_w.png

K1000: Help Building Work Report by Location with Department Breakdown

Hello all,

I am trying to formulate a report that would give me the following layout:

Location     # of Tickets    Total Hours worked

If it could then nest the following under each location:

Department     # of Tickets    Total Hours worked

 

So with filling some info in:

 

Location               # of Tickets         Total Hours Worked

 

Head Office           40                           80

 

  HR                     10                           20

 

  Accounting         30                           60

 

 

Hopefully this make sense.

We use the user’s Custom 1 field for the department and the user’s location field for the location.  This is updated from our AD imports.  We also store this info in custom 3 and 4 in the ticket.

I have only started this project but since I have very limited SQL knowledge I thought I would get a post going before I loose what is left of my hair.  ;)

As for a time frame to look at would like to be able to run this report for the last month, quarter and year.

This does not sound like a small order so many thanks in advance for any input.


1 Comment   [ + ] Show comment
  • You could do that via a SQL report. - Jbr32 11 years ago
    • That is my plan. I was hoping to get a little insight on what the SQL might look like. - smalls 11 years ago

Answers (0)

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ