Calendar Report for Change – Displaying Based on Status

[zee15]

Hi,

I want to create a calendar report for Change with the following requirements:

When a Change is submitted, till it is in the Review state, it should be displayed on the calendar based on the Planned Start Date and Planned End Date.
Once the Change is Closed, it should be displayed based on the Actual Start Date and Actual End Date.
Is it possible to configure the report to handle this logic? If so, how can I achieve this?

Right now this is the filter that is used in the report :

Any guidance would be greatly appreciated!

Thanks 

[Shivalika · Accepted solution]

Hello @zee15 

These are two different requirements. We cannot add if else kind of thing in reporting. You need to be specific that you want this data and then create a report. 

If you want these two different sets of data before and after review state in change request. It's recommended to create two different reports. 

Refer below servicenow documentation on calender reports - https://www.servicenow.com/docs/bundle/yokohama-now-intelligence/page/use/reporting/concept/c_Calend...

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Shivalika · Accepted solution]

Hello @zee15 

These are two different requirements. We cannot add if else kind of thing in reporting. You need to be specific that you want this data and then create a report. 

If you want these two different sets of data before and after review state in change request. It's recommended to create two different reports. 

Refer below servicenow documentation on calender reports - https://www.servicenow.com/docs/bundle/yokohama-now-intelligence/page/use/reporting/concept/c_Calend...

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Shivalika]

Hello @zee15 

Thanks for marking my answer as helpful.

Kindly accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeE

ISQCY

[Dr Atul G- LNG · Accepted solution]

Hi @zee15 

I tried using a dataset, but unfortunately, we can't create multiple datasets in the calendar report. You'll need to create two different reports based on 'State + Plan Dates' and 'State + Actual Dates.'