Avatar

Mark Saner

  • Total activity 18
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 8
  • Subscriptions 4

Activity overview

Latest activity by Mark Saner
  • Avatar

    Mark Saner commented,

    I think I got the weekday only sorted out. It required a few more Metrics. I created a Week Days Ticket Created: SELECT COUNT(Date (Ticket Created)) WHERE Day of Week (Mon-Sun) (Ticket Created) NOT...

  • Avatar

    Mark Saner commented,

    Thats it! Thanks Amy! I knew it had something to do with a BY ALL OTHER. So in this case does the BY ALL OTHER mean sort by Month/Year (Ticket Created) and ignore all other atributes and WITHOUTH P...

  • Avatar

    Mark Saner commented,

    Grame,   Thanks for the quick response. It got me a step farther. I created a "days in a month" metric using your code above and if I create another metric called "avg # Tickets Created per day mon...

  • Avatar

    Mark Saner created a post,

    Divide by number of days/Average Per day

    I'm trying to get a report that shows me the average number of tickets created per day month to month. So February would have the # Tickets Created/28 , Jan would be #Tickets Created/31 etc.  One w...

  • Avatar

    Mark Saner commented,

    Is there any way to change this report to a metric? I have a report I am creating that is a chart filtered out by assignee. It includes things like tickets assigned to that person, Tickets solved b...

  • Avatar

    Mark Saner commented,

    We have an automated e-mail that comes in from one of our vendors after an order is made. We need it to create a ticket but it keeps getting suspended as an automated response e-mail. I have whitel...