{"id":45295,"date":"2014-03-04T12:50:06","date_gmt":"2014-03-04T12:50:06","guid":{"rendered":"http:\/\/www.timestored.com\/b\/?p=45295"},"modified":"2014-03-04T12:50:06","modified_gmt":"2014-03-04T12:50:06","slug":"sql-dashboards-interactive-forms","status":"publish","type":"post","link":"https:\/\/www.timestored.com\/b\/sql-dashboards-interactive-forms\/","title":{"rendered":"sql Dashboards 1.31 Released &#8211; Interactive Forms"},"content":{"rendered":"<p><a href=\"\/sqldashboards\">sqlDashboards<\/a> is a tool for creating real-time sql based charts.<br \/>\nThe latest 1.31 release is available to <a href=\"\/sqldashboards\/download\">download<\/a>.<\/p>\n<p>Our new &#8220;Forms&#8221; now make the charts interactive. here&#8217;s an example dashboard showing some stock data, notice the form in the top left allowing selecting a stock ticker and the number of days data to show. On the bottom right is another form containing checkboxes for each country. We can change these selections and the charts will be updated instantly.<\/p>\n<p><a rel=\"lightbox[a]\" title=\"Example interactive sql Chart Form\"  href=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2014\/03\/sql-dashboards-sql-chart-form.png\"><img loading=\"lazy\" src=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2014\/03\/sql-dashboards-sql-chart-form.png\" alt=\"sql-dashboards-sql-chart-form\" width=\"558\" height=\"444\" class=\"alignnone size-full wp-image-45296\" srcset=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2014\/03\/sql-dashboards-sql-chart-form.png 837w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2014\/03\/sql-dashboards-sql-chart-form-300x238.png 300w\" sizes=\"(max-width: 558px) 100vw, 558px\" \/><\/a><\/p>\n<p>Now I modify my selection to ask for more days data, and untick some country checkboxes, to alter which ones are shown in the pie chart, the charts update straight away to give this:<\/p>\n<p><a rel=\"lightbox[a]\" title=\"Example interactive sql Chart Form\"  href=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2014\/03\/sql-dashboards-sql-chart-form-2.png\"><img loading=\"lazy\" src=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2014\/03\/sql-dashboards-sql-chart-form-2-300x238.png\" alt=\"sql-dashboards-sql-chart-form-2\" width=\"300\" height=\"238\" class=\"alignnone size-medium wp-image-45301\" srcset=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2014\/03\/sql-dashboards-sql-chart-form-2-300x238.png 300w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2014\/03\/sql-dashboards-sql-chart-form-2.png 838w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Full details on how to create forms can be found in the <a href=\"\/sqldashboards\/help\/\">sqlDashboards help<\/a>.<br \/>\nIf you use <strong>kdb<\/strong> see our &#8220;help menu&#8221;->Open example kdb dashboard option.<\/p>\n<h3>Multiple worksheets and Full Screen<\/h3>\n<p>Customers had asked us for to allow multiple worksheets, it&#8217;s now been added. As well as a new Full Screen mode to maximise display use when not editing the dashboard, the options can be found here:<\/p>\n<p><img loading=\"lazy\" src=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2014\/03\/sql-dashboards-full-screen-worksheets.png\" alt=\"sql dashboards full screen worksheets\" width=\"858\" height=\"214\" class=\"alignnone size-full wp-image-45306\" srcset=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2014\/03\/sql-dashboards-full-screen-worksheets.png 858w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2014\/03\/sql-dashboards-full-screen-worksheets-300x74.png 300w\" sizes=\"(max-width: 858px) 100vw, 858px\" \/><\/p>\n<p>We are going to continue to add new functionality&#8230;increasingly configurable charts, command line chart generation, web interfaces&#8230;if you have any features you would like added please <a href=\"\/contact?subject=sqlDashboards\">get in touch<\/a>, we are always happy to <a href=\"\/contact?subject=sqlDashboards\">receive feedback<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>sqlDashboards is a tool for creating real-time sql based charts. The latest 1.31 release is available to download. Our new &#8220;Forms&#8221; now make the charts interactive. here&#8217;s an example dashboard showing some stock data, notice the form in the top left allowing selecting a stock ticker and the number of days data to show. On [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/45295"}],"collection":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/comments?post=45295"}],"version-history":[{"count":13,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/45295\/revisions"}],"predecessor-version":[{"id":45317,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/45295\/revisions\/45317"}],"wp:attachment":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/media?parent=45295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/categories?post=45295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/tags?post=45295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}