Reporting on state duration

[lars7]

Hi

I have a requirement to make a report on how long resource plans in average have been in a specific state (requested). 

I have a metric definition that tracks the duration in the form of metric instances.

The thing is, I do not know how to bring this data into a report and I need help.

Cheers

[Abhijit4]

Hi,

You can try reporting on metric instance table from their you can dot walk and get resource plan details as per your requirement.

Let me know if you have any further queries.

Please mark this as Correct or Helpful if it helps.

Thanks and Regards,
Abhijit

[lars7]

Thanks Abhijit,

I had actually done what you suggested and i am able to show a report that gives me the avg duration in requested.

Now, I want to further expand this information with some drill-down reports. 

But I cant dotwalk from the metric instance to the resource plans which has the data I want.

For example, i would like to report on the distribution of the avg duration to maybe show how long specific resources are in requested state.

Got any suggestion??

[Abhijit4]

Hi,

Just looked into my PDI. Looks like we can't dot walk to get record details from metric instance table.

The other way I can think of is create Database view to merge metric instance and Resource plan table then you can report on Database view table where you will get all data that you want.

In case you are not sure how to implement Database view, you can find details on below link

Database views

There is OOTB database view written on metric instance, metric definition and incident table, you can use its reference, your requirement looks similar to it.

Let me know if you have any further queries.

Please mark this as Correct or Helpful if it helps.

Thanks and Regards,
Abhijit

[Abhijit4]

Hi,

If my answer helped you to resolve your issue then please mark appropriate answer as correct so that question will be removed from unsolved section and others also can get benefit from it.

Thanks and Regards,
Abhijit