Limit Explore queries on single attributes.

9 コメント

  • Hillary Latham
    Community Moderator

    Sounds like you need to add a filter for ticket type and just include incidents.  Metrics don't filter the data that gets returned in your rows - you still have to filter your data separately from the metrics you choose to display.

    1
  • David Hunter

    Thank you, Hillary.

    I've tried every permutation of filter on row, column, and general query and they seem to affect everything.

    All I am looking for is a list of NOT Closed or Solved Problems, and their linked Incidents regardless of status.

    When I filter by status, I get a great list of open Problems and its Open incidents, but it has filtered all of the closed incidents?

    0
  • Hillary Latham
    Community Moderator

    If this isn't working for you, can you show me your query?

    If I build what you describe, and add ticket status and type to my rows, and filter type for incidents, I get results of only incidents.  I also added Problem ID so you could see that I have tickets with linked problems, but I'm not showing problems in my result.

    0
  • David Hunter

    I also get those results.  My issue is further filtering down so that I dont see closed/Solved Problems.

    This query is very effective, however, it also removes Closed/Solved Incidents.

    II get the same results if I move the filter to a row like you have and filter it. It removes all closed/solved Problems and all closed/solved incidents.  Do I need to create an If-Then statement?

    0
  • David Hunter

    Moved to Row:

    0
  • David Hunter

    Here it is with no filters.  Note ID 66709, It now reads 7 Incidents, which Is what I want. It reports 5 when the filters are on. But with no filter, I have 100s of irrelevant records.

    0
  • Hillary Latham
    Community Moderator

    So if you only want New, Open, and Pending incidents, you need two filters.  One for type, to only show incidents, and one for status, to filter out solved and closed.  

    0
  • David Hunter

    Hillary, Thank you so much for your efforts, but I dont think you are seeing it.  If I add a filter to remove Solved/Closed from the query directly above, it affects both Problems and Incidents.  All I want is to filter the Problems. In need the Solved/Closed Incidents represented.

    It's ok though, ill try to determine an alternate avenue.

     

    Thank you again.

    0
  • Hillary Latham
    Community Moderator

    David, have you tried using a filter for Ticket Type?  Can you explain why that won't work for you? If you want all incident for all statuses (new, open, pending, solved, and closed) and no problems, all you need is a filter on ticket type.

    0

サインインしてコメントを残してください。

Powered by Zendesk