Database View or Metric?

[cherylkirkn]

I want to report on the approvals for a purchase order and how long it took to move from one approval to another.
I don't know which would work best, a metric or a database view. 
The key is getting the user defined department field in the report.
proc_po table is where the field, u_department has been added
sysapproval__approval table is where the field Approving is and that links to the PR.

I've created the Database view, but don't know what to put in the where clause.

Any advice would be helpful.  

[Dr Atul G- LNG]

 Hi @cherylkirkn 

DB and metrics are 2 different things. DB is used when you want to join 2 tables and there is at least 1 field common in both to join.  whereas Metric is used to calculate the difference, like how much time is between 2 stages.

I want to report on the approvals for a purchase order and how long it took to move from one approval to another.

Atul: For these results, you need to create the metric on the state.
I don't know which would work best, a metric or a database view. 
The key is getting the user-defined department field in the report. proc_po table is where the field, u_department has been added sysapproval__approval table is where the field Approving is and that links to the PR.

Atul: For this you need a  DB view and make sure there is one field common to get the where clause.

I've created the Database view, but don't know what to put in the where clause.

Any advice would be helpful.  

Atul: Please share DB view.