Changes between Version 6 and Version 7 of DygraphsVisualizationPlugin
- Timestamp:
- Aug 12, 2016, 7:26:53 AM (8 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DygraphsVisualizationPlugin
v6 v7 1 1 [[PageOutline(2-5,Contents,pullout)]] 2 2 3 = Create graphical reports using the MIT-licensedDygraphs charting library3 = Create graphical reports using the Dygraphs charting library 4 4 5 5 == Description 6 6 7 This plugin is based on Rob Guttman's [[VisualizationPlugin|Visualization Plugin]], except that it uses the MIT-licensed [ [http://dygraphs.com|Dygraphs]] charting library, instead of thehttps://developers.google.com/chart/?csw=1&safe=on Google Visualization API].7 This plugin is based on Rob Guttman's [[VisualizationPlugin|Visualization Plugin]], except that it uses the MIT-licensed [http://dygraphs.com Dygraphs] charting library, instead of the [https://developers.google.com/chart/?csw=1&safe=on Google Visualization API]. 8 8 9 9 This means that it can be legally used offline, which the Google APIs don't allow. There are corporate Trac installations that for various reasons can't be connected to the Internet. … … 54 54 === Report the history of tickets open and closed 55 55 56 It i often useful to be able to generate reports that span a period of time, for monitoring the progress of a project.56 It is often useful to be able to generate reports that span a period of time, for monitoring the progress of a project. 57 57 58 58 Constructing such reports is not always straightforward. Here's an example of a report that plots the number of tickets that were opened and closed throughout the duration of the project. It also plots the growth of the "backlog": the number of currently-open tickets at that time. 59 59 60 Note that this query uses Common Table Expressions. These have only been present in SQLite since [ [http://www.sqlite.org/releaselog/3_8_3.html|version 3.8.3]]. It will usually be necessary to update the version of `SQLITE3.DLL` in your Python installation's top-level `DLLs` folder to one compiled from SQLite 3.8.3 or later:60 Note that this query uses Common Table Expressions. These have only been present in SQLite since [http://www.sqlite.org/releaselog/3_8_3.html version 3.8.3]. It will usually be necessary to update the version of `SQLITE3.DLL` in your Python installation's top-level `DLLs` folder to one compiled from SQLite 3.8.3 or later: 61 61 62 62 {{{#!sql … … 110 110 === Report the number of open tickets with particular values of a custom field over time 111 111 112 Here i a more complex report that looks for tickets of type 'fault' that have a custom field 'safety_related'. At any time, this field can have one of three values that classify the safety status of the ticket: 'Not assessed', 'Safety related' or 'Not safety related'. The report plots the count of the number of open tickets with each safety status at the start of every week for the past three years:112 Here is a more complex report that looks for tickets of type 'fault' that have a custom field 'safety_related'. At any time, this field can have one of three values that classify the safety status of the ticket: 'Not assessed', 'Safety related' or 'Not safety related'. The report plots the count of the number of open tickets with each safety status at the start of every week for the past three years: 113 113 114 114 {{{#!sql