in

User Forum

Share best practices with other customers to get the best out of Navigator 2008.
Latest post 10-21-2008 10:52 AM by Brian H @ OakTree. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 10-20-2008 7:59 AM

    Day of the week reports

     For trending reasons, I would love to see a report that will show you stats by the day of the week.  For example - it would be great to see a report that shows number of incidents reported on each day of the week. i.e. Monday: 160 Tuesday: 100

    Or to be able to say:  "Show me incients reported by analyst on Thursdays"

     

    Not sure if this is possible, but it would be a great report to be able to filter on a specific day of the week.

    • Post Points: 20
  • 10-21-2008 10:52 AM In reply to

    Re: Day of the week reports

     Lauren,

    I do have a solution for this. I can post it to the how-to forum in the next couple of days.

    I also have a solution to show ticket counts by month that is very similar. I will post both.

    Basically, it requires a SQL Function to return the day of the week.(or month of year), then a call to this function can be added via the CUSTOMAHD.TXT features you use for other custom formula fields.

    Please stay tuned...I will update this thread when the How-To is posted.

     

    Thank you for using the Forum!!

    Brian

    Brian Holesapple

    --------------------------------------------------------------

    OakTree Enterprise Solutions Inc.

    www.oaktreenavigator.com

    www.oaktreesolutions.com

     

    • Post Points: 5
Page 1 of 1 (2 items)
© Copyright 2007 - 2008 OakTree Enterprise Solutions, Inc. All rights reserved.