30 | | TBD |
| 30 | This creates a gauge counting the number of rows returned in report number 10. |
| 31 | |
| 32 | {{{ |
| 33 | {{{ |
| 34 | #!JQChart |
| 35 | "type": "MeterGauge", |
| 36 | "report_id": 10, |
| 37 | "options" : { |
| 38 | "seriesDefaults": { |
| 39 | "rendererOptions": { |
| 40 | "label": "# bugs", |
| 41 | "intervals": [4, 8, 12] |
| 42 | } |
| 43 | } |
| 44 | } |
| 45 | }}} |
| 46 | }}} |
| 47 | |
| 48 | This creates a line chart with one series per ticket type. The x axis is the time the ticket was created, and the y axis is a 'cooked' number for demonstration only (the ticket id times 10). Notice that the sql query returns the ticket id. This will make each point in the chart clickable. When you click on a point, you will be sent to the ticket corresponding to that point. |
| 49 | |
| 50 | {{{ |
| 51 | {{{ |
| 52 | #!JQChart |
| 53 | "width": 400, |
| 54 | "height": 250, |
| 55 | "query": "select type, time, id * 10, id from ticket order by time", |
| 56 | "options" : { |
| 57 | "title": "Creation date of each ticket, by type" |
| 58 | }, |
| 59 | "series_column": "type" |
| 60 | }}} |
| 61 | }}} |
| 62 | |
| 63 | The options element is the jqplot options parameter. See jqplot for more information. |