Count location once (for this year) - Aggregation Count Distinct on Automated Indicator

mackc
Tera Contributor

Hi everyone,

 

We are on a Utah FSM platform.

I have a automated indicator on the weekly closed locations, which is based on an weekly indicator source that includes the closed work order tasks.

I want the number of worked at locations (a location that has at least one closed Work order task), the automated indicator thus has a count distinct on the location field.  

 

The requirement also contains that a location should only be counted once, at the timestamp the first workorder task is closed. This location should not be counted again even if there is a new workorder with this location after a set of time within the last and this year  (e.g. two months after the first wot completion).

 

Is it possible to use the scripted field to add a script to solve this issue, if so how?

0 REPLIES 0