Julianne

Sanjhosh, I typically identify maintenance periods with a value search that ignores short capsules. I then create a "Runs" condition with the following formula: Where the argument inside of the growend() function is the maximum amount of time you could spend in one run. You can then view the runs on top of each other using Capsule View as Thorsten described. Let us know if you have any more questions! Julianne

George, Great question! The green and blue sections of the code will be the same, but we will need to add a few additional variables (in orange) before we define our capsules. The new code will look like this: //Define a search window to look for now $searchPeriod = capsule('2018-12-01T00:00-08:00', '2020-01-01T00:00-08:00') //Identify now by finding the last available measured time stamp $now = $a.validvalues().toGroup($searchPeriod).last().getKey() //Define additional variables with helpful timestamps $midnight = $now.floorTime(1d) $yesterday = $midnight - 1d $month = $now.floorTime(1mo) $month2 = $month - 1month //Create capsules from the timestamp variables and combine them into one condition condition(32d, capsule($month2 , $month).setProperty("Time", "Last Month"), capsule($month, $now).setProperty("Time", "This Month") , capsule($yesterday, $midnight).setProperty("Time", "Yesterday"), capsule($midnight, $now).setProperty("Time", "Today")) Note that we are combining the red and purple steps above. In the next release of Seeq, we will have a now() function, so you will be able to skip the green and blue steps and just set $now = now(). Let me know if you have any additional questions!

Hi George, This is a common question. The trick is to create a condition that includes capsules for the last 7, 14, and 365 days and then use the "Condition" process type in the Scorecard metric. Note that these time periods could be whatever you like. The first step is to create the condition. You will do this in Seeq Formula with this code: //Define a search window to look for now $searchPeriod = capsule('2018-12-01T00:00-08:00', '2020-01-01T00:00-08:00') //Identify now by finding the last available measured time stamp $now = $a.validvalues().toGroup($searchPeriod).last().getKey() //Create conditions representing the last 7, 14, and 365 days $Last7DayCapsule = capsule($now-7d, $now).setProperty("Time","Last 7d") $Last14DayCapsule = capsule($now-14d, $now).setProperty("Time","Last 14d") $Last365DayCapsule = capsule($now-365d, $now).setProperty("Time","Last 365d") condition(370d,$Last7DayCapsule,$Last14DayCapsule,$Last365DayCapsule) The first section, in green, creates a period in which Seeq will search for "now." The second section, in blue, defines "now" as the timestamp of the last valid value of variable "a" within the search window. Seeq recommends using "Area A_Temperature" (included in your example data) as your variable "a." The third section, in purple, creates the capsules representing the last 7, 14, and 365 days. In this section, we are also creating a property on these capsules called "Time" and using this property to include text indicating the duration of the capsule. Finally, in the section in red, we combine these three capsules into one condition. The next step is to create the scorecard metric. To make your column header more concise, select "Capsule Property" as your column header and use the "Time" property created in the condition formula. You can add additional metrics as desired. The final product should look like this: