Database View - metric instance and custom table u_request

[Christine A1]

I am trying to build a report that will show time to resolve values for two tables, incident and a custom table u_request. I have modified the out of box metric for the Create to Resolve Duration so that it works for our requirements and have the same logic for each instance per table.

Next i created a database view that joins the u_request to the metric definition and instance tables.

From a reporting standpoint, i want to have the options to add additional filters on the database view, for ex. last 7 days, last month etc.

how would i accomplish this and also am i on the right track? note we do not have PA paid for so not sure if i can use indicators. I just need a way to report, the more pretty the better obviously 🙂

[Christine A1]

view is not selectable when i create a report with source type of Table. I do see other views but just not mine. note my view was created as a join between a task derived table and a metric table. might that be the problem? we do not have paid PA.

[Prateek kumar · Accepted solution]

Search with just Kmp_request_metric

[Christine A1]

thanks Prateek. that worked. i got side tracked because i was able to search up other db view starting with u_

looks like i know have a solution.