How can I display Jan-Dec (even if there is no data) on the horizontal axis of the graph?

[Yuta3553]

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.

[robkola]

So, the request was for showing data in past and future where "Months for which no data is registered " - for example if you want to show 2023 monthly figures, you have only for January, the default report will only show January and we would want January to December (knowing Feb-Dec is empty) just to show each month of the year - currently this script only generates a bar for January

[Community Alums]

Hi @robkola ,

For showing the data past and future you might have to select the 'Per' field accordingly. However, you will not be able to see the future months, if the data is not available. 

Regards,

Gagan k

[Yuta3553]

Thank you for your comment.

Regarding future months, I understood that if there is no data for a month, it will not be displayed.

By the way, for past months as well, if there is no data for a month, is it not displayed in the first place?

Regards,

[robkola]

So, how would you set up the reporting to create a bar chart like this?

No data in ServiceNow for February-December 2023 but I want to show the 'blanks'