Bar Chart Help needed

mateusz3
Mega Contributor

Hi There,

This question will be probably easy to answer to most people here. I am quite fresh in service now.

I want to create a bar chart that will display all created incidents on given days, preferably last 5 working days, starting from yesterday.

The conditions available in the reporting section are limiting the display of tickets to ''last 2-5 days'' 2-3 weeks etc. I understand where this is coming from, the system also considers the time an incident was created on, but I want only report on a raw date. For example date 04/02/16 = 20 , 03/02/16 = 26 and so on.

Any ideas?

Thank you in advance for help

1 ACCEPTED SOLUTION

Allison3
Kilo Guru

I think you're looking for a trend chart. You would set the trend field to opened on date.



How can I change the way the opened field is calculated for a report?


View solution in original post

9 REPLIES 9

gemini17
Kilo Guru

Hello Matt:



In the filter condition select: Created---------between---------Today----------and --------------Select from calendar icon a date of 5 days ago.   You can choose to add any additional conditions like 'category' etc.   Make sure you have lot of incidents created in the last five days.



Hope this is helpful.


P.S.. Mark it helpful and correct if it works.


Thanks


Danny


Hi Danny. Thanks for reply, unfortunately It did not really help. I select group by created. And the below happens. I do not want it to display ''same day'' , ''2 days'' and so on. I want it to show me the dates they were created, Any ideas?


chart.jpg


Matt,



Change the report type from Bar to Trend.   Then you can set the Trend by field to Created and the per field to Date.   Then you can set the filter to only show the days you are interested in.



chart.JPG



Steve


Allison3
Kilo Guru

I think you're looking for a trend chart. You would set the trend field to opened on date.



How can I change the way the opened field is calculated for a report?