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 🙂

[Apurva Malewad1]

Hi Christine,

As you already created database view combining all the needed tables.Now just create a report using this database view as a table and select other configuration settings like report type, group by field etc.After doing this you can add additional filter conditions in your reports like created on last 7 days etc.Then just run your report and see if you get the right data as you want.If any concerns, please let me know.You can refer below screenshots just for an example :

1.Table selected as database view name below:

2.Filter conditions can be added in report as below:

Please mark my answer as Correct/Helpful if it helps you to resolve your problem.

Regards,

Apurva

[Christine A1]

the problem is i cannot select the view from the list. i do see other views selectable from the list.

s that i cannot see the view from the list when i select table

[Apurva Malewad1]

Hi Christine,

Just to check that have you tried the Try it option for your database view?As it can happen if you got some error in database view then it might not show in table because generally it shows in table list of reports.This is something weird behavior.Along with this also check the ACLs for the database view on your system. If any concerns, please let me know.

Please mark my answer as Correct/Helpful if it helps you to solve your problem.

Regards,

Apurva

[Christine A1]

yes, i ran the try it option. data displayed as expected. might have something to do with coming from a metric table and reporting as opposed to coming from the PA env.