{"id":64837,"date":"2024-01-16T16:55:06","date_gmt":"2024-01-16T08:55:06","guid":{"rendered":"https:\/\/oihelp.corporate.ifs.com\/help\/?page_id=64837"},"modified":"2024-01-17T10:48:03","modified_gmt":"2024-01-17T02:48:03","slug":"large_sampled","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/large_sampled\/","title":{"rendered":"Large_Sampled()"},"content":{"rendered":"\n<h2>Format<\/h2>\n<p class=\"intro-text\"><strong>Large_Sampled(Expr ,ValueIndex ,StartTime [,EndTime] [,SampleMethod] [,SampleInterval])<\/strong><\/p>\n<h2>Returns<\/h2>\n<p class=\"intro-text\">Returns the nth largest value of the points in an expression over a range of time.<\/p>\n<h2>Inputs<\/h2>\n<p class=\"intro-text\"><b>Expr:\u00a0<\/b>The expression whose values should be processed to find nth largest value.<br \/>\nBehaviour: Required<br \/>\nDimensions: Expression<br \/>\nValid data types: Expression<\/p>\n<p class=\"intro-text\"><b>ValueIndex:\u00a0<\/b>The zero-based ordinal (n) of the value to return, i.e. use zero to return the largest value, use 1 to return the second largest value, etc. If the ordinal is greater than the number of values then an error will be returned.<br \/>\nBehaviour: Required<br \/>\nDimensions: SingleValue<br \/>\nValid data types: Integer<\/p>\n<p class=\"intro-text\"><b>StartTime:\u00a0<\/b>The start time over which to produce the nth largest value. Note: You can use the Time() function to use a valid DateTime argument.<br \/>\nBehaviour: Required<br \/>\nDimensions: Collection, SingleValue<br \/>\nValid data types: DateTime, Decimal, Integer, String<\/p>\n<p class=\"intro-text\"><b>EndTime:\u00a0<\/b>The end time over which to produce the nth largest value. Note: If not specified, it assumes the current time. You can use the Time() function to use a valid DateTime argument.<br \/>\nBehaviour: Optional<br \/>\nDimensions: Collection, SingleValue<br \/>\nValid data types: DateTime, Decimal, Integer, String<\/p>\n<p class=\"intro-text\"><b>SampleMethod:\u00a0<\/b>This optional parameter can be used to override the sample method which will be used for evaluating the expression (1st parameter).<br \/>\nBehaviour: Optional<br \/>\nDimensions: SingleValue<br \/>\nValid data types: String<\/p>\n<p class=\"intro-text\"><b>SampleInterval:\u00a0<\/b>This optional parameter can be used to override the sample interval which will be used for evaluating the expression (1st parameter).<br \/>\nBehaviour: Optional<br \/>\nDimensions: SingleValue<br \/>\nValid data types: DateTime, Decimal, Integer, String<\/p>\n<h2>Examples<\/h2>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Large_Sampled(Expr, 0, Time() - 60, Time())<\/span><br \/>\nResult: The largest value over the last minute (60 seconds).<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Large_Sampled(Expr, 1, Time() - 60)<\/span><br \/>\nResult: The second largest value over the last minute (60 seconds).<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Large_Sampled(Expr, 2, Midnight(Time()))<\/span><br \/>\nResult: The third largest value since midnight (the start of the day).<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Large_Sampled({tag, sampleMethod = \"Raw\"}, 0, Time() \u2013 60)<\/span><br \/>\nResult: The largest value of the raw values over the last minute.<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Large_Sampled(Sampling(Expr, \"raw\"), 1, Time() - 60)<\/span><br \/>\nResult: The second largest value of the raw values over the last minute.<\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Large_Sampled(Expr, 2, Time() - 7200, Time(), 'LastKnownValue', 3600)<\/span><br \/>\nResult: Evaluates the expression using the last known value sample method and 1-hour sample interval and returns its third largest value over the last 2 hours.<\/p>\n<h2><span id=\"Release_History\">Release History<\/span><\/h2>\n<ul class=\"intro-text\">\n<li>Large_Sampled() 4.9.10\n<ul class=\"intro-text\">\n<li>Initial version<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Large_Sampled() can be used to find the nth largest value in a time range.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/large_sampled\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":10316,"parent":3650,"menu_order":127,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[9],"tags":[1153,413],"class_list":["post-64837","page","type-page","status-publish","has-post-thumbnail","hentry","category-tech-ref","tag-large","tag-sampled","Version-4-9-10","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/64837","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=64837"}],"version-history":[{"count":9,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/64837\/revisions"}],"predecessor-version":[{"id":64864,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/64837\/revisions\/64864"}],"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\/10316"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=64837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=64837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=64837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}