Create a bar graph based on start and today date

[Hareesha]

I have a requirement to show in bargraph

0-1days

2-3 days

>3 days

It's calculated based on difference between request creation date and today's date. How can I achieve in Reports. Can anyone suggest?

[Amit Gujarathi]

HI @Hareesha ,
I trust you are doing great.

To achieve the desired result of displaying a bar graph based on the age of IT asset management requests, you can follow these steps in ServiceNow:

1. Create a new report in ServiceNow.
2. Define the report type as "Bar Chart" to display the data in a bar graph format.
3. Specify the table from which you want to fetch the data. In this case, it would be the table containing the IT asset management requests.
4. Configure the report to include the following fields: "Request Creation Date" and "Today's Date" (current date).
5. Add a filter to the report to calculate the age of the requests. The condition will be based on the difference between the "Request Creation Date" and "Today's Date".
6. Set the filter conditions to categorize the requests into the desired age ranges:
   • For requests created within 0-1 days, use the condition: "Difference is less than or equal to 1".
   • For requests created within 2-3 days, use the condition: "Difference is greater than 1 and less than or equal to 3".
   • For requests created more than 3 days ago, use the condition: "Difference is greater than 3".
7. Configure the report to display the categorized data in a bar graph format.
8. Customize the appearance of the graph by setting appropriate labels, colors, and axis titles.
9. Save the report and share it with the intended audience.

[Hareesha]

I Amit,

I am unable to set the filter condition that you have suggested. I am unable to see the Difference in report. Can you help me on this.Thanks!

[AndersBGS]

Hi @Hareesha ,

You need to look into report ranges to create the ranges you have specified in your question. You can see the documentation here: https://docs.servicenow.com/en-US/bundle/utah-now-intelligence/page/use/reporting/concept/c_ReportRa...

Afterwards, you create a bar chart graph based on created date whit the condition that the request is not resolved, closed or completed (your choices my differ), and whatever conditions you might need.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[AndersBGS]

Hi @Hareesha 

if my answer has helped with your question, please mark my answer as accepted solution.

best regards

Anders