{"id":10141,"date":"2016-02-25T09:23:59","date_gmt":"2016-02-25T01:23:59","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=10141"},"modified":"2024-08-15T10:31:31","modified_gmt":"2024-08-15T02:31:31","slug":"stddev_sampled","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/stddev_sampled\/","title":{"rendered":"StdDev_Sampled()"},"content":{"rendered":"\n<h2>Format<\/h2>\n<p class=\"intro-text\"><strong>StdDev_Sampled(Expr,StartTime[,EndTime])<\/strong><\/p>\n<h2>Returns<\/h2>\n<p class=\"intro-text\">Returns the standard deviation\u00a0of the values of an expression over a range of time.<\/p>\n<p class=\"left-bar-yellow\">It is possible to retrieve very large volumes of data through indiscriminate use of this function. Retrieving large amounts of Historian data across a slow network can affect system performance for all users of the system.<\/p>\n<h2>Inputs<\/h2>\n<p class=\"intro-text\"><strong>Expr<\/strong>: The expression whose values should be processed to find the standard deviation. Which values are processed\u00a0will depend on how the expression is sampled.<br \/>\n Behaviour: Required<br \/>\n Dimension:\u00a0Collection<br \/>\n Valid\u00a0data types:\u00a0Decimal, Duration, Integer<\/p>\n<p class=\"intro-text\"><strong>StartTime<\/strong>: The start time over which to produce the standard deviation.<br \/>\n Behaviour: Required <br \/>\n Dimension: Collection, SingleValue<br \/>\n Valid data types: DateTime, Decimal, Integer, String<\/p>\n<p class=\"intro-text\"><strong>EndTime<\/strong>: The end time over which to produce the standard deviation.\u00a0If not specified, it assumes <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/time\/\">Time<\/a>(), which will return a list of timestamps between the StartTime and EndTime parameters.<br \/>\n Behaviour: Optional\u00a0<br \/>\n Dimension: Collection, SingleValue<br \/>\n Valid data types: DateTime, Decimal, Integer, String<\/p>\n<p class=\"left-bar\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/calculation-syntax\/#Data_Type\">How to format data types<\/a><\/p>\n<h2>Examples<\/h2>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">StdDev_Sampled(Expr, Time() - 60, Time())<\/span><br \/>\n Result: Standard deviation\u00a0over the last minute (60 seconds)<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">StdDev_Sampled(Expr, Time() - 60)<\/span><br \/>\n Result: Standard deviation\u00a0over the last minute (60 seconds)<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">StdDev_Sampled(Expr, Midnight(Time()))<\/span><br \/>\n Result: Standard deviation\u00a0since midnight (the start of the day)<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">StdDev_Sampled({tag, sampleMethod = \"Raw\"}, Time() \u2013 60)<\/span><br \/>\n Result: Standard deviation\u00a0of the raw values over the last minute<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">StdDev_Sampled(Sampling(Expr, \"raw\"), Time() - 60)<\/span><br \/>\n Result: Standard deviation\u00a0of the raw values over the last minute<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use StdDev_Sampled() to get the standard deviation of the values of an expression over a range of time<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/stddev_sampled\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":10159,"parent":3650,"menu_order":205,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[9],"tags":[100,395],"class_list":["post-10141","page","type-page","status-publish","has-post-thumbnail","hentry","category-tech-ref","tag-calculations","tag-standard-deviation","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/10141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=10141"}],"version-history":[{"count":1,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/10141\/revisions"}],"predecessor-version":[{"id":46248,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/10141\/revisions\/46248"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/3650"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/10159"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=10141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=10141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=10141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}