Top 5 Fields per Month

3 Comentarios

  • Brandon Tidd
    Community Moderator

    Hi Christina - 


    Thanks for writing in.  Would you be able to share details or a screen shot of how your currently pulling the data in Explore?  We might be able to just tweak your settings slightly.  Looking forward to hearing back.

     

    Brandon Tidd
    729 Solutions

    0
  • Christina

    Hi Brandon Tidd-

    Metrics is just COUNT(Tickets), Columns is Ticket Created - Week of Year, and I'm using this for Rows:

    The result is that it gives me the Top 5 Store Categories of all time, instead of the top 5 for that particular week. Here's the overall look:

    I know for instance in the third week here, there was an issue that would have been a top 5 category, but it doesn't show up here.

    0
  • Brandon Tidd
    Community Moderator

    Hi Christina -

     

    Thanks for the additional information!  Have you tried adding a date filter to your query?  That might solve your problem.  Hope this helps!

    Brandon Tidd
    729 Solutions

    0

Iniciar sesión para dejar un comentario.

Tecnología de Zendesk