Across the table operation

[LeoYang]

Hello,

I have this data,(see image 1 below) .

I want to calculate the number of repair for the InstrumentID within 1 year after preventive maintenance(PM) .

How to write this metric.

• The field name for the preventive maintenance(PM) is "Date-PM"

• The field name for the repair is "Date-Repair"

• This condition is "Date-PM < Date-Repair < Date-PM +365 days" 
• The metric are run in a table (see image 2 below)

Image 1

Image 2

I'll be glad to have some help!!!

Thanks