In metric report it will show 3 same records at the time of form submitted, I want to populate only

[Anwesh]

In metric report it will show 3 same records at the time of form submitted, I want to populate only first one. Thanks in advance.

@

@Mike_R 

@Ankur Bawiskar 

@Mark Roethof 

@Gunjan Kiratkar  

[Anwesh]

Thanks for your time, I create this report for custom application it have multiple stages, I want to calculate each stage duration.  

[Sebas Di Loreto]

@Anwesh 

Thanks for the screen.

I can see the metric definition is extremely simple (field value duration) because it is just following the different values on the "NO PO NO PAY Current Step" field.

I can see the table is a customized one: "NO PO NO PAY".

First you have to understand how are these metrics triggered. Having a metric defined is the first step, but they are triggered by a business rule called "metrics events".

You can find it here: /sys_script.do?sys_id=35f9861dc0a808ae00ecf631cc51888c

This out of the box business rule is the one that generates the metric records in the  metric_instance table. But that business rule applies for the TASK table.

When I wanted to generate metrics on the interaction table for example, I had to copy that business rule in the interaction table.

Have you done something similar to what I did for the interaction table but on your customized table? If the metrics are being logged more than once, that could be problem...