Hello All,Please help me I'm a begineer of servicenow developer.
I'm currently trying to create a graph showing the "total number" of CI(configuration_item)on a monthly basis for my company's project
However, the current issue is that it is difficult to display the "total number" of CIs on a monthly basis, and it is only possible to display the "created" CIs on a monthly basis.
In the above example, I would expect the following values.
1 for Mar,2019
7 for Sep,2019
8 for Sep,2020
21 for July,2022
24 for Jan,2023
Ideally, we would like to output a graph showing the total number of CIs each month, but can anyone tell us how to do this?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
■Configuration of attached file's bar graph(For reference)
■Data
Report name:CI Report(monthly transition)
Source Type:Table
Table:configuration_item
■Type
Trend
■Configure
Group by:Class
☑Display data table
Aggregatio:Count
Per:Month
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I would greatly appreciate it if you could let me know.
Thank you in advance.
Hi @Yuta3553 ,
You have to create a Trend Chart to achieve the requirement you are looking for. Below screenshot should help you to achieve it.
P.S - Make sure you select trend chart as type of graph.
Please mark helpful/like, if the solution is in line with your expectation.
Regards,
Gagan k
.png){kind=link}