need two create report on two metric definition

[PinkuM]

Hi

My requirement is to create report on task table to calculate time how much time ticket spent in work in progress state.

-This i achieved by create metric definition but now the issue is when WIP ticket assigned to another person time spent show over all time for that user as my previous definition run on state field.

can anyone suggest me the better way to achieved this.

Thanks in advance!

[Dr Atul G- LNG]

Hi @PinkuM 

In this case, you need to create another metric for "Assigned To" and then join these two metrics to build the results.

[PinkuM]

Could you please share few details how to join two metrics? 

[Dr Atul G- LNG]

Hi @PinkuM 

Two metrics are similar to two tables, meaning you need to identify what is common in both and then build a query, similar to how we build for other tables.