Reporting on metrics with database views

[jcmings]

I am trying to run a report on the Duration cases are assigned to different Assignment Groups. I am using the OOTB metric Assignment Group Duration for HR Case. 

However, I want to filter on specific columns on my HR Case table, so I created a database view that links HR Case, Metric, and Metric Instance. In my report, I'm pulling off of the Database View for my table, grouping by Assignment group, and aggregating based on the average Duration. 

I also want to run a report on the Duration cases are in each Request Status. Do I need to create another metric? Or can I just run the report on the same database view and change the filter/group by? I'm a little confused on the purpose of creating metrics now that I can just modify the filter/group by being run on the database view for the report.

[AndersBGS]

Hi @jcmings ,

In relation to your database view, are you utilizing left join on any of the tables?

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

Best regards
Anders