Skip to main content
Solved

Viewing number of tickets submitted for each User/Asset

  • November 8, 2024
  • 4 replies
  • 122 views
B
Forum|alt.badge.img+1

Our administration office has reached out to us and asked if we would be able to pull some information for them that lets us see who our most frequent flyers are.

I am looking for a way to filter the asset list by number of tickets that have been submitted for that asset. In doing so we can determine which of our students have brought their chromebooks to us the most.

Is there an elegant way to do this? I took a look through the columns available in the view builder and the filters and did not see anything.

Best answer by AMeyer Greendale Schools

You might be able to get some of that using the Analytics, but I typically build a ticket or asset view with the field(s) I need and export it. Then I’ll use Google Sheets/Excel to fine-tune the data.

    4 replies

    A
    Mentor
    Forum|alt.badge.img+9

    You might be able to get some of that using the Analytics, but I typically build a ticket or asset view with the field(s) I need and export it. Then I’ll use Google Sheets/Excel to fine-tune the data.

    Alyssa Meyer - Tech Lady, Superhero & Guru (depending on who you ask)
    Kathryn Carter
    Forum|alt.badge.img+18
    • Kathryn Carter
    • Community Manager
    • November 11, 2024

    @BGlover 300f99a penntrafford Thank you for submitting your question to our community! 😄

    There are a few threads in the community and @AMeyer Greendale Schools makes a great point about creating a table or graph within excel. Here is an idea to upvote about getting better tracking like this:

     

    Kathryn Carter - Community Moderator /// Did you ask a question? Don't forget to mark the correct answer!
    B
    Forum|alt.badge.img+1

    You might be able to get some of that using the Analytics, but I typically build a ticket or asset view with the field(s) I need and export it. Then I’ll use Google Sheets/Excel to fine-tune the data.

    This did what I was looking for. I was able to create a ticket view for our chromebook models then export it and sort in an Excel sheet by asset tag, and then highlight duplicate values.

     

    This could be a solution all it’s own, especially if it was possible to list the owner of the asset that the ticket was linked to. Being able to view the asset owner would cut out the step of having to look up the asset in question in IIQ again.

    A
    Mentor
    Forum|alt.badge.img+9

    You might be able to get some of that using the Analytics, but I typically build a ticket or asset view with the field(s) I need and export it. Then I’ll use Google Sheets/Excel to fine-tune the data.

    This did what I was looking for. I was able to create a ticket view for our chromebook models then export it and sort in an Excel sheet by asset tag, and then highlight duplicate values.

     

    This could be a solution all it’s own, especially if it was possible to list the owner of the asset that the ticket was linked to. Being able to view the asset owner would cut out the step of having to look up the asset in question in IIQ again.

    I sometimes will do 2 exports - one with the tickets, including asset tag, and a second with the asset tags & owner information. I do an index match to pull the user data over to the ticket tab in my sheet.

     

    Your ticket export should be able to include some owner data, but that depends on how the ticket was submitted, I think.

    Alyssa Meyer - Tech Lady, Superhero & Guru (depending on who you ask)
    Kathryn Carter
    Terms & ConditionsCookie settingsAccessibility statement
    Incident IQ logo

    Incident IQ is a service management platform built for K-12 school districts, featuring asset management, help ticketing, facilities maintenance solutions, and more.

    Corporate Headquarters:
    750 Glenwood Ave SE, Suite 320
    Atlanta, GA 30316