{"id":3017,"date":"2019-03-25T17:42:18","date_gmt":"2019-03-25T20:42:18","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/"},"modified":"2020-01-23T10:44:16","modified_gmt":"2020-01-23T13:44:16","slug":"kb51478-setting-up-e3chart-to-display-only-the-desired-period","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/","title":{"rendered":"KB-51478: Setting up E3Chart to display only the desired period."},"content":{"rendered":"
\n

Question:<\/b><\/p>\n

How can I set up a query per date in an E3Chart plotting historical data, and then set up the horizontal axis to automatically show the selected\/queried time interval?<\/p>\n

Solution:<\/b><\/p>\n

Among E3Chart’s properties, two of them are of great importance when you need to change the period in the grid’s main horizontal axis:<\/p>\n

HorScaleBegin <\/i>property<\/b>: determines the initial value applied to the grid’s main horizontal axis. This value can be a numeric one for XY E3Charts, or a Data one for E3Charts with a fixed time scale.<\/p>\n

HorScaleEnd <\/i>property<\/b>: determines the final value applied to the grid’s main horizontal axis. These properties must be attributed with the right values to adjust the horizontal axis.<\/p>\n

In addition to defining the time interval in the horizontal axis, you must query the database to search for the saved information and the chosen period. Considering the E3Chart is set up to query the database and that the desired pens have already been created, the next step is to insert a filter in this query’s E3TimeStamp field, then only the desired period will be displayed. The figure below illustrates how to include this filter.<\/p>\n

Example:<\/p>\n

\"\"<\/div>\n

The settings for the E3Chart are now ready; next, you will have to configure how to pass the values of the initial and final dates to E3Chart’s query. One way to it is by inserting two SetPoints onto a screen, the first one for the initial date and the second one for the final date, which will capture the period requested by the user; also onto the same screen, insert a Button that will pass (via scripts) these values to E3Chart and its query. You can use the following script:<\/p>\n

Example:
\n<\/b>
\nSub CommandButton1_Click()
\n‘ Instantiates initialdate and finaldate by loading values from the SetPoints with the chosen dates<\/span>
\ninitialdate=Screen.Item(“Text1”).Value
\nfinaldate=Screen.Item(“Text2”).Value
\nSet E3Chart1 = Screen.Item(“E3Chart1”)<\/span><\/p>\n

‘ Sets the horizontal axis scale via HorScaleBegin and HorScaleEnd properties<\/span>
\nE3Chart1.HorScaleBegin = initialdate
\nE3Chart1.HorScaleEnd = finaldate<\/p>\n

‘ Sends values to initialdate and finaldate variables created at E3Chart’s query’s filter<\/span>
\nScreen.Item(“E3Chart1”).Item(“Query1”).SetVariableValue “initialdate”, initialdate
\nScreen.Item(“E3Chart1”).Item(“Query1”).SetVariableValue “finaldate”, finaldate<\/p>\n

‘ Updates the query at E3Chart<\/span>
\nScreen.Item(“E3Chart1”).Queries.UpdateData()
\nEnd Sub<\/p>\n

Attachments:<\/h3>\n

Sample.zip<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Question: How can I set up a query per date in an E3Chart plotting historical data, and then set up the horizontal axis to automatically show the selected\/queried time interval?…<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[742],"tags":[],"yoast_head":"\nKB-51478: Setting up E3Chart to display only the desired period. - Elipse Knowledgebase<\/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:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-51478: Setting up E3Chart to display only the desired period.\" \/>\n<meta property=\"og:description\" content=\"Question: How can I set up a query per date in an E3Chart plotting historical data, and then set up the horizontal axis to automatically show the selected\/queried time interval?…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:42:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-23T13:44:16+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4694\/Figura1.png\" \/>\n<meta name=\"author\" content=\"Gabriel Manara\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gabriel Manara\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/\"},\"author\":{\"name\":\"Gabriel Manara\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/62f73726da552619d723db2fd82e3530\"},\"headline\":\"KB-51478: Setting up E3Chart to display only the desired period.\",\"datePublished\":\"2019-03-25T20:42:18+00:00\",\"dateModified\":\"2020-01-23T13:44:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/\"},\"wordCount\":409,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"E3Chart\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/\",\"name\":\"[:pt]KB-51478: Setting up E3Chart to display only the desired period.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:42:18+00:00\",\"dateModified\":\"2020-01-23T13:44:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-51478: Setting up E3Chart to display only the desired period.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/62f73726da552619d723db2fd82e3530\",\"name\":\"Gabriel Manara\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8f08450bea42667090b5d00999160306?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8f08450bea42667090b5d00999160306?s=96&d=mm&r=g\",\"caption\":\"Gabriel Manara\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/manara\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-51478: Setting up E3Chart to display only the desired period. - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-51478: Setting up E3Chart to display only the desired period.[:] - Elipse Knowledgebase","og_description":"Question: How can I set up a query per date in an E3Chart plotting historical data, and then set up the horizontal axis to automatically show the selected\/queried time interval?…","og_url":"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:42:18+00:00","article_modified_time":"2020-01-23T13:44:16+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4694\/Figura1.png"}],"author":"Gabriel Manara","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gabriel Manara","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/"},"author":{"name":"Gabriel Manara","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/62f73726da552619d723db2fd82e3530"},"headline":"KB-51478: Setting up E3Chart to display only the desired period.","datePublished":"2019-03-25T20:42:18+00:00","dateModified":"2020-01-23T13:44:16+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/"},"wordCount":409,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["E3Chart"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/","url":"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/","name":"[:pt]KB-51478: Setting up E3Chart to display only the desired period.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:42:18+00:00","dateModified":"2020-01-23T13:44:16+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/kb51478-setting-up-e3chart-to-display-only-the-desired-period\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-51478: Setting up E3Chart to display only the desired period."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/62f73726da552619d723db2fd82e3530","name":"Gabriel Manara","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8f08450bea42667090b5d00999160306?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8f08450bea42667090b5d00999160306?s=96&d=mm&r=g","caption":"Gabriel Manara"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/manara\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3017"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=3017"}],"version-history":[{"count":3,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3017\/revisions"}],"predecessor-version":[{"id":5074,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3017\/revisions\/5074"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}