Reporting

[Community Alums]

Need to have a report which is displaying the below Operational status and its change in numbers on monthly basis.

Pending use

Installed

Build complete

In active

Commissioned

Please let me know if there is any suggestions/solution.

Thanks in advance,

Chaithanya

[AndersBGS]

Hi @Community Alums ,

If you need to display changes on a monthly basis, you need to utilize performance analytics. 

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

best regards

Anders

[Dr Atul G- LNG]

Hi @Community Alums 

As mentioned correctly by @AndersBGS you need to use PA. I am thinking metrics but that will tell you how many time a records moved between the status. Might be give a try. 

[Community Alums]

Hi @Dr Atul G- LNG  and @AndersBGS 

Thanks for the reply, could you please provide me the steps that how I can achieve this thorough PA.

Thanks in advance,

Chaithanya

[Dr Atul G- LNG]

Hi @Community Alums 

I want to go for metrics first. Create a metric on the status, then create a database view with the CMDB table and metric and use that DB view for the report. You can check ootb metric on incident state and same DB view as well.