LGuth
Engaged Sweeper
since ‎02-15-2019
‎07-11-2022

User Statistics

  • 5 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

Does anyone have a report for the Top 10 users submitting tickets by month for the current year?
I would like to have a report showing the top 10 users that have submitted tickets by month and year.I'm not real savvy on writing code.Could someone help me?Linda Guth====Maybe this report below that shows the top Ticket Types can be modified to sho...
I found this code, but it only shows me the current month.How do I edit it, so that it shows the top 10 ticket types for Year To Date, by month for the current year?Select Top 10 DatePart(yyyy, htblticket.date) As Year, DatePart(mm, htblticket.date) ...
I found this code, but it only shows me the current month.How do I edit it, so that it shows the top 10 ticket types for Year To Date for the current year?Select Top 10 DatePart(yyyy, htblticket.date) As Year,DatePart(mm, htblticket.date) As Month,'....