{"id":23811,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/historic-point-time-reports-1\/"},"modified":"2025-02-06T18:27:19","modified_gmt":"2025-02-07T02:27:19","slug":"historic-point-time-reports-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-1\/","title":{"rendered":"Historic Point-in-Time Reports"},"content":{"rendered":"<p>Using the option labeled <strong>Generate report as of this date<\/strong>, you can look at the data in a report, as of the date you enter.<\/p>\n<p><img decoding=\"async\" style=\"width: 90%;\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/point-in-time-reports.png\" alt=\"\" \/><\/p>\n<p>The report that is generated will display the results as of the date that you enter.\u00a0 Note the following:<\/p>\n<ul>\n<li>Point in Time filters are available for Column, Summary, Matrix, Aging, Treegrid, Dashboard, Container and Custom report types\n<ul>\n<li>You cannot drilldown from a point-in-time aging report, as the results are not useful<\/li>\n<li>Dashboard and Container reports may or may not contain reports which have point-in-time date options set.\u00a0 In these report types, the dates set will override the dates set within the individual reports<\/li>\n<li>Custom URL reports will require custom code to support the feature<\/li>\n<\/ul>\n<\/li>\n<li>All issues that are retrieved for point-in-time reports compare the date entered in the report editor to the last modified date (the TIMESTAMP field within the database)<\/li>\n<li>The title of the report is modified to highlight the point in time which is used to generate the report, thereby clarifying that the report is not displaying current information<\/li>\n<li>You may use $$SYSDAY$$ or $$SYSDATE$$ as the date for the point-in-time report.\u00a0 For example, if you want to generate a report that always showed yesterday&#8217;s results, you can set $$SYSDAY$$-1 as the date<\/li>\n<li>If the report contained filters that used $$SYSDAY$$ or $$SYSDATE$$ as values, then these values will be replaced with the same date that you entered into the <strong>Generate report as of this date<\/strong> field.Example: To generate a report so that it always returns the data as of the close of business on the previous day, use $$SYSDAY$$ &#8211; 1 as the entry<\/li>\n<li>You may use the $$RUNTIME$$ token as the date for the results to be generated.\u00a0 The runtime filter screen will prompt for the date when running the report<\/li>\n<li>Any drilldown from the report, by clicking on a value within a Summary or Matrix report, or clicking on the Edit button within a Column report will show the current results, not the historic result.\u00a0 This prevents you from attempting to edit the historic values within any issue as this would be a contravention of the audit trail that is maintained within all issues<\/li>\n<li>The date used for the point-in-time results will be displayed on the report output, in the user&#8217;s personal date \/ time format.\u00a0 Within workspaces this is found by mousing over the user button which displays who prepared the report along with the date and time<\/li>\n<li>If your administrator imported legacy issue data into ExtraView from a remote source, the TIMESTAMP on these records reflects the actual date and time the records were imported.\u00a0 This is not likely to be the same date and time the records were created and point-in-time reports are not likely to display the results that you expect.\u00a0 This is the correct behavior, and cannot be altered, as it is imperative that ExtraView&#8217;s audit trail correctly records the transactions.\u00a0 Note that the Date Created field (DATE_CREATED) may be altered on the import of issue data, but the date last modified (TIMESTAMP) field is independent of this<\/li>\n<li>Within workspaces, dragging and dropping issues to and from point-in-time reports is disabled<\/li>\n<li>You cannot perform a mass update from the output of a point-in-time report<\/li>\n<li>You cannot perform a Quickedit operation from a poin-in-time report.\u00a0 If a Quickedit button is placed on a point-in-time report, it will not be rendered.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Using the option labeled Generate report as of this date, you can look at the data in a report, as of the date you enter. The report that is generated will display the results as of the date that you enter.\u00a0 Note the following: Point in Time filters are available for Column, Summary, Matrix, Aging,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":23802,"menu_order":8,"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-23811","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Historic Point-in-Time Reports - 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\/common-report-functions-1\/historic-point-time-reports-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Historic Point-in-Time Reports - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Using the option labeled Generate report as of this date, you can look at the data in a report, as of the date you enter. The report that is generated will display the results as of the date that you enter.\u00a0 Note the following: Point in Time filters are available for Column, Summary, Matrix, Aging,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-07T02:27:19+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=\"3 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\/common-report-functions-1\/historic-point-time-reports-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-1\/\",\"name\":\"Historic Point-in-Time Reports - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-07T02:27:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-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\":\"Common Report Functions\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Historic Point-in-Time Reports\"}]},{\"@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":"Historic Point-in-Time Reports - 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\/common-report-functions-1\/historic-point-time-reports-1\/","og_locale":"en_US","og_type":"article","og_title":"Historic Point-in-Time Reports - Product Documentation","og_description":"Using the option labeled Generate report as of this date, you can look at the data in a report, as of the date you enter. The report that is generated will display the results as of the date that you enter.\u00a0 Note the following: Point in Time filters are available for Column, Summary, Matrix, Aging,...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-07T02:27:19+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-1\/","name":"Historic Point-in-Time Reports - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-07T02:27:19+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/historic-point-time-reports-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":"Common Report Functions","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/"},{"@type":"ListItem","position":6,"name":"Historic Point-in-Time Reports"}]},{"@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\/23811","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=23811"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23811\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23802"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=23811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}