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

Allison, would you know how te set the widh of a collumn on a trend/bar chart? Below is an example, I want this to be thinner. If I will get only 1-2 records, or groups, they are taking the whole chart. Which does not look good visually.



Thanks in Advance.


2016-02-10 15-26-34_ServiceNow.jpg


Can you show me how you have the report set up? It looks like you might have a filter set that's dumping the column all in to one day.


Sure. Here it is. I could only run it for todays date, as my company still didnt go live with it. But the date displays now on the bottom (Thanks!)


I just noticed if I have 1 or 2 bars to display on the chart they are massive.


2016-02-10 15-26-34_ServiceNow.jpg


Since you it grouped by opened and there is only one date that tickets have been opened there is only one bar. You would need to change your filter of opened on today. Once you add more days (bars) that one bar will get smaller.



Here's an example of one we have:


find_real_file.png



find_real_file.png


Hmm ok. I understand now. So there is no way to set this manually?