{"id":23825,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/calculated-fields-1\/"},"modified":"2025-02-06T19:15:47","modified_gmt":"2025-02-07T03:15:47","slug":"calculated-fields-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/","title":{"rendered":"Calculated Fields"},"content":{"rendered":"

Not every filter that can be used or field that can be displayed is a field with data explicitly entered or updated by the user. For example, ExtraView will automatically calculate the values for fields defined internally. These fields and their meanings are:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n\t\t\t\tField Name<\/td>\n\n\t\t\t\tDefault Title<\/td>\n\n\t\t\t\tPurpose<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CLOSED<\/td>\n\n\t\t\t\tDate Closed<\/td>\n\n\t\t\t\tThe date and time the issue was closed.<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CLOSED_MONTH<\/td>\n\n\t\t\t\tDate Closed Month<\/td>\n\n\t\t\t\tThe month the issue was closed (useful when summarizing information)<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CLOSED_SINCE<\/td>\n\n\t\t\t\tDays Since Closed<\/td>\n\n\t\t\t\tThe number of days since the issue was closed. Days are calculated using your own time zone, back to midnight for the first day (this is zero days since closed) and then incremented by one for each further day back in time that you go<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CLOSED_WEEK<\/td>\n\n\t\t\t\tDate Closed Week<\/td>\n\n\t\t\t\tThe week the issue was closed<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CLOSED_YEAR<\/td>\n\n\t\t\t\tDate Closed Year<\/td>\n\n\t\t\t\tThe year the issue was closed<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CREATED<\/td>\n\n\t\t\t\tDay Created<\/td>\n\n\t\t\t\tThe date and time the issue was created.<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CREATED _MONTH<\/td>\n\n\t\t\t\tMonth Created<\/td>\n\n\t\t\t\tThe month the issue was created (useful when summarizing information)<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CREATED _SINCE<\/td>\n\n\t\t\t\tDays Since Created<\/td>\n\n\t\t\t\tThe number of days since the issue was created. Days are calculated using your own time zone, back to midnight for the first day (this is zero days since created) and then incremented by one for each further day back in time that you go<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CREATED_TRUNC<\/td>\n\n\t\t\t\tCreated<\/td>\n\n\t\t\t\tThe date the issue was created<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CREATED _WEEK<\/td>\n\n\t\t\t\tWeek Created<\/td>\n\n\t\t\t\tThe week the issue was created<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_CREATED _YEAR<\/td>\n\n\t\t\t\tYear Created<\/td>\n\n\t\t\t\tThe year the issue was created<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_LAST_STATUS_CHANGE<\/td>\n\n\t\t\t\tDate of Last Status Change<\/td>\n\n\t\t\t\tThe date and time of the last status change<\/td>\n<\/tr>\n
\n\t\t\t\tDATE_LAST_STATUS_ CHANGE_SINCE<\/td>\n\n\t\t\t\tDays Since Last Status Change<\/td>\n\n\t\t\t\tThe number of days since the last status change. Days are calculated using your own time zone, back to midnight for the first day (this is zero days since the last status change) and then incremented by one for each further day back in time that you go<\/td>\n<\/tr>\n
\n\t\t\t\tDAYS_IN_STATUS<\/td>\n\n\t\t\t\tDays in Status<\/td>\n\n\t\t\t\tThe number of days the issue has remained in its current status<\/td>\n<\/tr>\n
\n\t\t\t\tDAYS_OPEN<\/td>\n\n\t\t\t\tDays Open<\/td>\n\n\t\t\t\tThe number of days since the issue was created until it was placed in a Closed <\/em>status.<\/td>\n<\/tr>\n
\n\t\t\t\tEV_TOP_RANK<\/td>\n\n\t\t\t\tTop-n rank filter<\/td>\n\n\t\t\t\tThis field only applies to summary reports. When it is applied, you enter a positive number. For example, if you enter 10, then the results displayed will only contain the ten results with the highest values. This is useful if you want to provide a summary count of issues where there are many rows returned, but only those with the highest n<\/em> count may have useful data. Note that this feature is not supported on all databases. If your installation is utilizing MySQL as its underlying database, then this feature is inoperable.<\/td>\n<\/tr>\n
\n\t\t\t\tMONTHS_IN_STATUS<\/td>\n\n\t\t\t\tMonths in Status<\/td>\n\n\t\t\t\tThe number of months (defined as 30-day periods) that the issue has been in its present status<\/td>\n<\/tr>\n
\n\t\t\t\tMONTHS_OPEN<\/td>\n\n\t\t\t\tMonths Open<\/td>\n\n\t\t\t\tThe number of days since the issue was created until it was placed in a Closed <\/em>status.<\/td>\n<\/tr>\n
\n\t\t\t\tSTART_DATE<\/td>\n\n\t\t\t\tCreated Start Date<\/td>\n\n\t\t\t\tUsed as a filter to determine the created day from which to start counting issues<\/td>\n<\/tr>\n
\n\t\t\t\tSTART_UPDATE<\/td>\n\n\t\t\t\tUpdated Start Date<\/td>\n\n\t\t\t\tUsed as a filter to determine the last day modified from which to start counting issues<\/td>\n<\/tr>\n
\n\t\t\t\tSTOP_DATE<\/td>\n\n\t\t\t\tCreated Stop Date<\/td>\n\n\t\t\t\tUsed as a filter to determine the created day to which you want to count issues<\/td>\n<\/tr>\n
\n\t\t\t\tSTOP_UPDATE<\/td>\n\n\t\t\t\tUpdated Stop Date<\/td>\n\n\t\t\t\tUsed as a filter to determine the last day modified to which you want to count issues<\/td>\n<\/tr>\n
\n\t\t\t\tTIMESTAMP<\/td>\n\n\t\t\t\tLast Modified<\/td>\n\n\t\t\t\tThe day and time an issue was last modified<\/td>\n<\/tr>\n
\n\t\t\t\tTIMESTAMP_DAY<\/td>\n\n\t\t\t\tDay Last Modified<\/td>\n\n\t\t\t\tThe day an issue was last modified<\/td>\n<\/tr>\n
\n\t\t\t\tTIMESTAMP_MONTH<\/td>\n\n\t\t\t\tMonth Last Modified<\/td>\n\n\t\t\t\tThe month an issue was last modified<\/td>\n<\/tr>\n
\n\t\t\t\tTIMESTAMP_SINCE<\/td>\n\n\t\t\t\tDays Since Last Modified<\/td>\n\n\t\t\t\tThe number of days since an issue was last modified. Days are calculated using your own time zone, back to midnight for the first day (this is zero days since last modified) and then incremented by one for each further day back in time that you go<\/td>\n<\/tr>\n
\n\t\t\t\tTIMESTAMP_TRUNC<\/td>\n\n\t\t\t\tLast Modified<\/td>\n\n\t\t\t\tThe day an issue was last modified<\/td>\n<\/tr>\n
\n\t\t\t\tTIMESTAMP_WEEK<\/td>\n\n\t\t\t\tWeek Last Modified<\/td>\n\n\t\t\t\tThe week an issue was last updated<\/td>\n<\/tr>\n
\n\t\t\t\tTIMESTAMP_YEAR<\/td>\n\n\t\t\t\tYear Last Modified<\/td>\n\n\t\t\t\tThe year an issue was last updated<\/td>\n<\/tr>\n
\n\t\t\t\tWEEKS_IN_STATUS<\/td>\n\n\t\t\t\tWeeks In Status<\/td>\n\n\t\t\t\tThe number of weeks an issue has remained in its present status<\/td>\n<\/tr>\n
\n\t\t\t\tWEEKS_OPEN<\/td>\n\n\t\t\t\tWeeks Open<\/td>\n\n\t\t\t\tThe number of weeks since an issue was created until it was placed in a Closed <\/em>status.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Not every filter that can be used or field that can be displayed is a field with data explicitly entered or updated by the user. For example, ExtraView will automatically calculate the values for fields defined internally. These fields and their meanings are: Field Name Default Title Purpose DATE_CLOSED Date Closed The date and time…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":23769,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-23825","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nCalculated Fields - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculated Fields - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Not every filter that can be used or field that can be displayed is a field with data explicitly entered or updated by the user. For example, ExtraView will automatically calculate the values for fields defined internally. These fields and their meanings are: Field Name Default Title Purpose DATE_CLOSED Date Closed The date and time...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-07T03:15:47+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/\",\"name\":\"Calculated Fields - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-07T03:15:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"End User Guide\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Reporting\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Calculated Fields\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calculated Fields - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/","og_locale":"en_US","og_type":"article","og_title":"Calculated Fields - Product Documentation","og_description":"Not every filter that can be used or field that can be displayed is a field with data explicitly entered or updated by the user. For example, ExtraView will automatically calculate the values for fields defined internally. These fields and their meanings are: Field Name Default Title Purpose DATE_CLOSED Date Closed The date and time...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-07T03:15:47+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/","name":"Calculated Fields - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-07T03:15:47+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/calculated-fields-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"End User Guide","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/"},{"@type":"ListItem","position":4,"name":"Reporting","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/"},{"@type":"ListItem","position":5,"name":"Calculated Fields"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=23825"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23825\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23769"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=23825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}