Report issue

[CecileC]

Hi, 

I need your help with a report issue:

I need to create a report with all incident from the last month that, at a certain point in the process, have been placed on (state) on hold, and (on hold reason) awaing vendor.

All this information is available in the notes and i'm not sure which table to use or how to bring out this information. Do you have any idea? 

[AndersBGS · Accepted solution]

Hi @CecileC ,

you need to create the report based on the inccident_metric table, and create the report based on the metric_defirion called state or similar. This will ensure to capture the data that you’re looking for.

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

Best regards

Anders

[CecileC]

Thank you! It was the table I was looking for. Because I wanted the "on hold reason" information, I had to create a new metric for this field, and because it's a new metric, I don't have the information for the past incidents. Do you know if there is a way to be able to have access of this information for the last month incident so I can add it to my report?