Skip to main content
Nimit Bhardwaj が「#Number」で質問

I have to prepare a visual where I can show the state of open tickets and their age. I've been able to achieve this by creating a calculated field to calculate the age for an open ticket.

where [Date] is the date of creation of the ticket and '# of Days Open' indicated the age of the ticket.

 

The visualization comes out to be:

The problem for me is that I don't want to see so many bars. How can I convert the horizontal axis to intervals of 5? So tickets with age from 1-5 are stacked together, similarly for 6-10,11-15 and so on.

 

Thanks in advance.

6 件の回答
  1. 2018年9月6日 4:53

    Hello Nimit,

    Right click on your measure and create Bin

    Hello Nimit,Right click on your measure and create Bin PLEASE MARK IT AS CORRECT ANSWER IF IT HELPED IN ANSWERING YOUR QUESTION

    pastedImage_1.png

     

    PLEASE MARK IT AS CORRECT ANSWER IF IT HELPED IN ANSWERING YOUR QUESTION

0/9000