Slicing data by ticket tag

Respondida

4 Comentários

  • Marie-Cathrine Sørensen
    Community Moderator

    Hi Vladimir,

    You can create a report similar to the one in your image by following these steps:

    1. In metrics, add Tickets
    2. In columns, add Ticket created - Year and Ticket created - Month
    3. In rows, add Ticket tag (select the tags you want in the report)
    4. Select the visualisation type Column
    5. Select all tags in the row selector:
    6. Go to Chart configuration > Chart and set the settings like this:
    7. Go to Chart configuration > Displayed values and set Show values to Show and Position to Inside
    8. Go to Chart configuration > Row selector and remove the checkmark from Display row selector

    You should now have a report that looks very similar to the one you have created in Insights. 

    I hope this helped you in the right direction, if not, let me know and I will try to help :) 

    #helpsome regards,
    Marie-Cathrine Sørensen
    Business Intelligence Specialist & Junior Developer @ helphouse.io

    0
  • Vladimir Petrushenka

    Hi Marie-Cathrine,

    Thanks so much for this. I've managed to replicate the report. Much appreciate your help. 

    The only thing that looks odd in my query is that total values are missing for some of the months for some reason. Pls see the screenshot below. 

    Do you know what that can be? 

    Thanks again for your help

    Vladimir 

    0
  • Marie-Cathrine Sørensen
    Community Moderator

    Hi,

    This could be caused by the fact that the top section is rather small. Could you try and go to Chat configuration > Displayed values and remove the checkmark from Hide text collisions to see if that helps? 

    #helpsome regards,
    Marie-Cathrine Sørensen
    Business Intelligence Specialist & Junior Developer @ helphouse.io

    0
  • Vladimir Petrushenka

    Brilliant, that did help. Thanks so much again for your help 

    0

Por favor, entrar para comentar.

Powered by Zendesk