Count location once (for this year) - Aggregation Count Distinct on Automated Indicator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-29-2024 07:09 AM
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?
- Labels:
-
Performance Analytics