{"id":9679,"date":"2016-02-22T10:30:07","date_gmt":"2016-02-22T02:30:07","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=9679"},"modified":"2024-01-17T10:47:58","modified_gmt":"2024-01-17T02:47:58","slug":"count_sampled","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/count_sampled\/","title":{"rendered":"Count_Sampled()"},"content":{"rendered":"\n<h2><span id=\"Format\">Format<\/span><\/h2>\n<p class=\"intro-text\"><strong>Count_Sampled(Expr ,StartTime [,EndTime])<\/strong><\/p>\n<p class=\"left-bar\">Note: This function was named\u00a0<em>NumSamples<\/em> in v2.6.<\/p>\n<h2><span id=\"Returns\">Returns<\/span><\/h2>\n<p class=\"intro-text\">Returns the number of samples in 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><span id=\"Parameters\">Inputs<\/span><\/h2>\n<p class=\"intro-text\"><strong>Expr<\/strong>: The expression whose values should be counted.<br \/>\n Behaviour: Required<br \/>\n Dimension:\u00a0Collection<br \/>\n Valid\u00a0data types: Boolean, DateTime, Decimal, Integer, String, Duration, Error, Null<\/p>\n<p class=\"intro-text\"><strong>StartTime<\/strong>: The start time over which to produce the count.\u00a0<br \/>\n Behaviour: Required <br \/>\n Dimension: Collection, SingleValue<br \/>\n Valid data types: DateTime, Decimal, Integer, String<\/p>\n<p class=\"left-bar-p2blue\">Note: You can use the <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/time\/\">Time<\/a>() function to use a valid DateTime argument.<\/p>\n<p class=\"intro-text\"><strong>EndTime<\/strong>: The end time over which to produce the count.\u00a0If not specified, it assumes the current time.\u00a0<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-p2blue\">Note: You can use the <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/time\/\">Time<\/a>() function to use a valid DateTime argument.<\/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><span id=\"Examples\">Examples<\/span><\/h2>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Count_Sampled(Expr, Time() - 60, Time())<\/span><br \/>\n Result:\u00a0Number of samples over the last minute (60 seconds).<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Count_Sampled(Expr, Time() - 60)<\/span><br \/>\n Result:\u00a0Number of samples over the last minute (60 seconds).<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Count_Sampled(Expr, Midnight(Time()))<\/span><br \/>\n Result:\u00a0Number of samples since midnight (the start of the day).<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Count_Sampled({tag, sampleMethod = \"Raw\"}, Time() \u2013 60)<\/span><br \/>\n Result:\u00a0Number of raw values over the last minute.<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Count_Sampled(Sampling(Expr, \"raw\"), Time() - 60)<\/span><br \/>\n Result:\u00a0Number of raw values over the last minute.<\/p>\n<p class=\"intro-text\">\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use Count_Sampled() to get the number of samples in 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\/count_sampled\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":9689,"parent":3650,"menu_order":70,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[9],"tags":[100,413,367],"class_list":["post-9679","page","type-page","status-publish","has-post-thumbnail","hentry","category-tech-ref","tag-calculations","tag-sampled","tag-sumsamples","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/9679","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=9679"}],"version-history":[{"count":1,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/9679\/revisions"}],"predecessor-version":[{"id":46192,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/9679\/revisions\/46192"}],"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\/9689"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=9679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=9679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=9679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}