Hello All,Please help me I'm a begineer of servicenow developer.
Currently I am looking to create a CI graph for a year (Jan-Dec) from a "Report" (Reports- Create New).
But as it stands, it only shows the months for which CI data is registered (May, Oct, Nov, Dec, 2022).
Months for which no data is registered (Jan, Feb, Mar, Apr, Jun, Jul, Aug, Sep, 2022) are not displayed in the first place.
My ideal would be to have a full year (Jan-Dec) displayed on the horizontal axis of the graph, even for months with no data (Jan,2,3,4,6,7,8,9,2022). (The image is as follows. The yellow marker area has no data, but it is displayed. However, this is an example of a "year" unit.)
Is it possible to set the horizontal axis of the graph on the "Report" (Reports- Create New) using the system property settings or by changing/controlling the report?
(For reference, I'm using the "Sandiego" version)
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.
Hi @robkola ,
You need to select the Graph Type as Trend and Select the Trend type field to 'Created' and Per Field to 'Monthly'. Please find the screenshot for your perusal.
Please mark helpful/like if the solution is in line with your expectation.
Regards,
Gagan k
Hi @Yuta3553
Hope you will be fine.
I am created report on incident table. I have selected column chart according to the your chart style. There is three things are very important while configure.
- trend by => created
- calendar => standard calendar
- per => month
If my solution is helpful for you then mark helpful/like
Regards
Naveed
