Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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