Changes between Version 6 and Version 7 of DygraphsVisualizationPlugin


Ignore:
Timestamp:
Aug 12, 2016, 7:26:53 AM (3 years ago)
Author:
figaro
Comment:

Further cosmetic changes

Legend:

Unmodified
Added
Removed
Modified
  • DygraphsVisualizationPlugin

    v6 v7  
    11[[PageOutline(2-5,Contents,pullout)]]
    22
    3 = Create graphical reports using the MIT-licensed Dygraphs charting library
     3= Create graphical reports using the Dygraphs charting library
    44
    55== Description
    66
    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].
     7This 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].
    88
    99This 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.
     
    5454=== Report the history of tickets open and closed
    5555
    56 It ioften useful to be able to generate reports that span a period of time, for monitoring the progress of a project.
     56It is often useful to be able to generate reports that span a period of time, for monitoring the progress of a project.
    5757
    5858Constructing 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.
    5959
    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:
     60Note 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:
    6161
    6262{{{#!sql
     
    110110=== Report the number of open tickets with particular values of a custom field over time
    111111
    112 Here ia 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:
     112Here 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:
    113113
    114114{{{#!sql