-
Notifications
You must be signed in to change notification settings - Fork 3
/
report.html
627 lines (608 loc) · 44.7 KB
/
report.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
<!DOCTYPE html>
<html>
<head>
<title>Report- Plus</title>
<link href="css/tablesorter.css" rel="stylesheet" type="text/css">
<link href="css/tooltip.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="css/jquery-ui-custom.min.css">
<link href="css/jquery.qtip.min.css" rel="stylesheet" type="text/css">
<link href="css/plottable.css" rel="stylesheet" type="text/css">
<link href="css/bsmselect.css" rel="stylesheet" type="text/css">
<link href="css/style.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="libs/jquery.min.js"></script>
<script type="text/javascript" src="libs/jquery-ui.custom.min.js"></script>
<script type="text/javascript" src="libs/jquery.tablesorter.js"></script>
<script type="text/javascript" src="libs/jquery.qtip.min.js"></script>
<script type="text/javascript" src="libs/dialog-polyfill.js"></script>
<script type="text/javascript" src="libs/bsmselect.js"></script>
<script type="text/javascript" src="libs/d3.min.js"></script>
<script type="text/javascript" src="libs/plottable.min.js"></script>
<script type="text/javascript" src="libs/excellentexport.js"></script>
<script type="text/javascript" src="libs/dom-to-image.min.js"></script>
<script type="text/javascript" src="shared.js"></script>
<script type="text/javascript" src="sharedmobile.js"></script>
<script type="text/javascript" src="sharedsync.js"></script>
<script type="text/javascript" src="report.js"></script>
<style>
.report_class_white_text {
color:white !important; /* Needs to be here and not in style.css, we dont want background to inherit, so when user copies and pastes to excel, text will be black, not white */
}
</style>
</head>
<body style="font-family: Helvetica Neue,Arial,Helvetica,sans-serif;font-size: 1em;margin-bottom:0px;margin-top:5px;overflow:hidden;" class="agile_report_minSize">
<div id="divMain" style="margin:0;padding:0;display:none;">
<div class="agile_toplevel_report_container">
<div id= "report_top_section" align="center" style="margin-bottom:10px;margin-top:10px;">
<div style="position:absolute;left:5em;top:1em;" id="progress">
<span id="progressText"></span><span style="margin-left:1em;" id="progressAnim"></span>
</div>
<div style="width:100%" id="agile_title_header_report">
<button disabled style="float:left;height: 20px; width:47px;padding: 0px; margin-top: 2px; padding-left: 2px; padding-right: 2px" id="buttonFilter">•••</button>
<span id="report_title_text"> </span>
<span id="report_title_rightLinks" style="display:none;">
<button id="buttonMarkallRead" style="margin-left: 2em; margin-top: 0; margin-bottom: 0;display: none; ">Mark all viewed</button>
<a style="float:right;text-decoration:none;cursor:help;font-size:110%;margin-right:1em;" href="http://www.plusfortrello.com/p/report-documentation-and-examples.html" target="_blank" title="¡dlǝɥ">Help</a>
<span id="agile_reload_page">data changed. <b><a href="" target="_self" id="agile_reload_page_link">Reload</a></b> </span>
</span>
<img src="" style="display:none;" class="agile_img_popup" id="dockoutImg" title='Dock out' />
<img src="" style="display:none;" class="agile_img_popup" id="backImg" title='Back' />
</div>
</div>
<div class="agile_report_filters">
<div class="agile_report_filter agile_alternate_filterPos">
</div>
<div class="report_tooltip">
Filter by Plus keywords.<br />
<br />
To find NOT containing, start with !<br />
<a href="http://www.plusfortrello.com/p/report-documentation-and-examples.html#reportfilters" target="_blank">Supports multiple AND/OR/NOT.</a>
</div>
<div style="display:none" class="agile_report_filter">
<p class="agile_report_filter_label">Keyword</p>
<input class="agile_report_filter_input_long" autocomplete="on" spellcheck="false" maxlength="800" placeholder="contains..." type="text" id="keyword" name="keyword" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
Group resulting rows to the level of detail you need.<br />
Each resulting row will show the sum of its grouped numeric fields (counts, S/E/R and custom fields).<br />
<br />
Grouping affects the Report and Chart tabs.<br />
When grouping by 'S/E rows', cards without S/E do not appear in the report.<br />
<br />
'User' refers to those with S/E, not card members.
</div>
<div class="agile_report_filter agile_groupby_report_section">
<p class="agile_report_filter_label">Group by</p>
<select id="groupBy" style="width:9.5em;">
<option value="" title="With this option the report will be based solely on 'S/E rows'.\nCards without S/E will not show.\nSuch cards, lists and boards show in other group options .">S/E rows</option>
<option value="user">User (S/E user)</option>
<option value="idTeamH" title="Groups resulting cards and 'S/E rows' by team.\nColumns like 'date' use the newest row in each team.">Team</option>
<option value="idTeamH-user" title="Groups resulting cards and 'S/E rows' by team & user.\nColumns like 'date' use the newest row in each team.">Team-User</option>
<option value="idBoardH" title="Groups resulting cards and 'S/E rows' by board.\nColumns like 'date' use the newest row in each board.">Board</option>
<option value="idBoardH-nameList" title="Groups resulting cards and 'S/E rows' by unique board & list combination.">Board-List</option>
<option value="idBoardH-nameList-hashtagFirst" title="Groups by board, list & first #tag in the card">Board-List-hashtag1</option>
<option value="idBoardH-nameList-user" title="Groups by board, list & card S/E user">Board-List-User</option>
<option value="idBoardH-hashtagFirst" title="Groups by board & first #tag in the card">Board-Hashtag1</option>
<option value="idBoardH-user" title="Groups resulting 'S/E rows' by board & user combination.\n'user' groups are only for 'S/E rows'.">Board-User</option>
<option value="comment" title="Groups by the S/E note">S/E Note</option>
<option value="labels" title="Groups by labels in the card (makes duplicated rows on cards with multiple labels)">Labels</option>
<option value="hashtags" title="Groups by #tags in the card (makes duplicated rows on cards with multiple #tags)">Hashtags</option>
<option value="hashtagFirst" title="Groups by the first #tag in the card">Hashtag1</option>
<option value="user-hashtagFirst" title="Groups by user & first #tag in the card">User-Hashtag1</option>
<option value="idCardH" title="Groups resulting cards and 'S/E rows' by their card.\nColumns like 'date' use the newest row in each card.">Card</option>
<option value="idCardH-user" title="Groups resulting 'S/E rows' by card & user combination.\n'user' groups are only for 'S/E rows'.">Card-User</option>
<option value="month">Month</option>
<option value="week">Week</option>
<option value="idBoardH-week">Board-Week</option>
<option value="idBoardH-month">Board-Month</option>
<option value="user-week">User-Week</option>
<option value="user-month">User-Month</option>
<option value="dateString">Date</option>
<option value="dateString-user">Date-User</option>
<option value="dateString-idBoardH">Date-Board</option>
<option value="dateString-idCardH">Date-Card</option>
<option value="keyword">Keyword</option>
<option value="user-keyword">User-Keyword</option>
<option value="idBoardH-keyword">Board-Keyword</option>
<option value="idTeamH-keyword">Team-Keyword</option>
<option value="custom">Custom / Help...</option>
</select>
</div>
<div class="report_tooltip">
Pick a pivot to change the columns in the 'Spent by ...' tabs.<br />
<br />
If you do not need to pivot, using 'Year' will make the report a little faster.
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">Pivot by</p>
<select id="pivotBy">
<option value="year">Year</option>
<option value="month">Month</option>
<option value="">Week</option>
<option value="day">Day</option>
</select>
</div>
<div class="report_tooltip">
Order resulting rows. Also click report headers to change order (SHIFT-click for multi-column).<br />
<br />
When the card has S/E rows, the row date is based on S/E rows.<br />
Otherwise its the date of the card's last create, move or rename.<br />
<br />
Special orders:<br />
<br />
<b>R (non-zero)</b><br />
Special 'Remaining' report. Shows only rows with non-zero R.<br />
This order makes sense with filter 'since: All dates' and group by card,list,board,team or user.<br />
To show S/E columns, group by Card-User.<br />
<br />
To sort by R without this special behavior, order by something else, query, then click the R column header.<br />
<br />
<b>Due date</b><br />
only shows cards with a due date, and only works when grouping by Card or Card-User.<br />
<br />
<b>List position</b><br />
orders first by board name (descending) then by list position in each Trello board.
</div>
<div class="agile_report_filter agile_orderby_report_section">
<p class="agile_report_filter_label">Order by</p>
<select id="orderBy">
<option value="date">Date</option>
<option value="dateDue" title="Only valid with card grouping. Shows only cards with due dates.">Due date</option>
<option value="remain" title="Also removes all zero R.">R (non-zero)</option>
<option value="spent">S</option>
<option value="est">E</option>
<option value="user">User</option>
<option value="nameBoard">Board</option>
<option value="nameList">List name</option>
<option value="posList">List position</option>
<option value="nameCard">Card</option>
<option value="keyword">Keyword</option>
</select>
</div>
<div class="report_tooltip">
Filter by date.<br />
To pick start or end dates, pick 'Advanced'.<br />
<br />
When the card has S/E rows, the date in that report row is based on S/E rows.<br />
Otherwise it uses the date of the card's last create, move or rename.
</div>
<div class="agile_report_filter" id="groupDateSimple">
<p class="agile_report_filter_label">Since</p>
<select id="sinceSimple">
<option value="d-1">Today</option>
<option value="d-2">2 days</option>
<option value="d-3">3 days</option>
<option value="d-4">4 days</option>
<option value="d-5">5 days</option>
<option value="d-6">6 days</option>
<option value="d-7">7 days</option>
<option value="w-1">This week</option>
<option value="w-2">2 weeks</option>
<option value="w-3">3 weeks</option>
<option value="w-4">4 weeks</option>
<option value="w-5">5 weeks</option>
<option value="w-10">10 weeks</option>
<option value="w-15">15 weeks</option>
<option value="w-30">30 weeks</option>
<option value="w-53">53 weeks</option>
<option value="">All dates</option>
<option value="advanced">Advanced</option>
</select>
</div>
<div class="agile_report_filter_group" id="groupDateAdvanced">
<div class="report_tooltip">
Valid formats:<br />
2014<br />
2014-W12<br />
<br />
Using a week filter only shows results that have S/E.
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">Week start</p><input autocomplete="on" spellcheck="false" maxlength="8" class="agile_report_filter_input_short" placeholder="begins with..." type="text" id="weekStart" name="weekStart" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
Valid formats:<br />
2014<br />
2014-W15<br />
<br />
Using a week filter only shows results that have S/E.
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">Week end</p><input autocomplete="on" spellcheck="false" maxlength="8" class="agile_report_filter_input_short" placeholder="begins with..." type="text" id="weekEnd" name="weekEnd" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
Valid formats:<br />
2014 (year)<br />
2014-02 (month)<br />
2014-02-09 (full date)
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">Date start</p><input autocomplete="on" spellcheck="false" maxlength="10" class="agile_report_filter_input_short" placeholder="begins with..." type="text" id="monthStart" name="monthStart" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
Valid formats:<br />
2014 (year)<br />
2014-07 (month)<br />
2014-07-03 (full date)
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">Date end</p><input autocomplete="on" spellcheck="false" maxlength="10" class="agile_report_filter_input_short" placeholder="begins with..." type="text" id="monthEnd" name="monthEnd" /><input type="submit" class="agile_hidden" />
</div>
</div>
<div class="report_tooltip">
Filter by users that have S/E on cards.<br />
This does not filter by card members.<br />
Filtering by user will only show results that have S/E.<br />
<br />
To find NOT containing, start with !<br />
<a href="http://www.plusfortrello.com/p/report-documentation-and-examples.html#reportfilters" target="_blank">Supports multiple AND/OR/NOT.</a>
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">User</p>
<input class="agile_report_filter_input_long" autocomplete="on" spellcheck="false" maxlength="800" placeholder="contains..." type="text" id="user" name="user" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
To find NOT containing, start with !<br />
<a href="http://www.plusfortrello.com/p/report-documentation-and-examples.html#reportfilters" target="_blank">Supports multiple AND/OR/NOT.</a>
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">Team</p>
<input class="agile_report_filter_input_long" autocomplete="on" spellcheck="false" maxlength="800" placeholder="contains..." type="text" id="team" name="team" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
To find NOT containing, start with !<br />
<a href="http://www.plusfortrello.com/p/report-documentation-and-examples.html#reportfilters" target="_blank">Supports multiple AND/OR/NOT.</a>
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">Board</p>
<input class="agile_report_filter_input_long" autocomplete="on" spellcheck="false" maxlength="800" placeholder="contains..." type="text" id="board" name="board" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
To find NOT containing, start with !<br />
<br />
Example:
<br /><i><b>!doing</b></i>: finds history on cards with lists not containing 'doing'<br />
<a href="http://www.plusfortrello.com/p/report-documentation-and-examples.html#reportfilters" target="_blank">Supports multiple AND/OR/NOT.</a>
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">List</p><input class="agile_report_filter_input_long" autocomplete="on" spellcheck="false" maxlength="800" placeholder="contains..." type="text" id="list" name="list" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
To find NOT containing, start with !<br />
<br />
Examples:<br />
• <i><b>title1 or title2</b></i>: finds cards with titles containing 'title1' or 'title2'<br />
• <i><b>!#low</b></i> finds cards without a '#low' hashtag.<br />
<br />
<a href="http://www.plusfortrello.com/p/report-documentation-and-examples.html#reportfilters" target="_blank">Supports multiple AND/OR/NOT.</a>
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">Card</p><input class="agile_report_filter_input_long" autocomplete="off" spellcheck="false" maxlength="800" placeholder="contains..." type="text" id="card" name="card" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
Filter by card labels.<br />
<br />
To find NOT containing, start with !<br />
<a href="http://www.plusfortrello.com/p/report-documentation-and-examples.html#reportfilters" target="_blank">Partially supports AND/OR</a>:
<br />
When using <b>OR</b>, no term can be negated: label1 OR label2 OR label3<br />
When using <b>AND</b>, all terms must be negated: !label1 AND !label2 AND !label3<br />
If you need a more complex filter, export the report results to a spreadsheet using 'Copy'.<br />
<br />
<b>Labels sync note: </b>Plus automatic sync does not always detect all card labeling changes that happened within the last two minutes before sync, or label names on boards where the only change was a renamed label.<br />
To force fresh card label results in those cases click on sync from the Chrome Plus menu or the top weekly report in Trello.
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">Label</p>
<input class="agile_report_filter_input_long" autocomplete="on" spellcheck="false" maxlength="800" placeholder="contains..." type="text" id="label" name="label" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
To find NOT containing, start with !<br />
<br />
Filtering by S/E note will only show results that have S/E.<br />
<a href="http://www.plusfortrello.com/p/report-documentation-and-examples.html#reportfilters" target="_blank">Supports multiple AND/OR/NOT.</a>
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">Note</p><input class="agile_report_filter_input_long" autocomplete="on" spellcheck="false" maxlength="800" placeholder="contains..." type="text" id="comment" name="comment" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
Filter by archived card, list or board.
</div>
<div style="display:none" class="agile_report_filter">
<p class="agile_report_filter_label">Archived</p>
<select id="archived">
<option value="-1">All</option>
<option value="1">Archived</option>
<option value="0" selected="selected">Not Archived</option>
</select>
</div>
<div class="report_tooltip">
Filter by deleted card.
</div>
<div style="display:none" class="agile_report_filter">
<p class="agile_report_filter_label">Deleted</p>
<select id="deleted">
<option value="-1">All</option>
<option value="1">Deleted</option>
<option value="0" selected="selected">Not Deleted</option>
</select>
</div>
<div class="report_tooltip">
Leave blank for all boards or type the board shortLink from its URL<br />
<br />
trello.com/b/<b>shortLink</b>/
</div>
<div style="display:none" class="agile_report_filter"><p class="agile_report_filter_label">Board shortLink</p><input class="agile_report_filter_input_long" autocomplete="on" spellcheck="false" maxlength="40" placeholder="is..." type="text" id="idBoard" name="idBoard" /></div>
<div class="report_tooltip">
Leave blank for all cards or type the card shortLink from its URL<br />
<br />
trello.com/c/<b>shortLink</b>/
</div>
<div style="display:none" class="agile_report_filter"><p class="agile_report_filter_label">Card shortLink</p><input class="agile_report_filter_input_long" autocomplete="on" spellcheck="false" maxlength="40" placeholder="is..." type="text" id="idCard" name="idCard" /></div>
<div class="report_tooltip">
Show only rows after this row number.<br />
Leave blank to display all.
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">After row</p><input class="agile_report_filter_input_short" autocomplete="on" spellcheck="false" maxlength="6" placeholder="row number" type="text" id="afterRow" name="afterRow" /><input type="submit" class="agile_hidden" />
</div>
<div class="report_tooltip">
Filter by estimate type.<br />
<br />
• All: No E. type filter.<br />
• E 1ˢᵗ: rows with a first estimate<br />
• +E: rows that increased the card estimate per user<br />
• -E: rows that decreased it
</div>
<div class="agile_report_filter">
<p class="agile_report_filter_label">E. type</p>
<select id="eType">
<option value="all">All</option>
<option value="enew">E 1ˢᵗ</option>
<option value="eincr">+E</option>
<option value="edecr">-E</option>
</select>
</div>
</div>
<div style="display:none;" id="templatesContainer" class="agile_arrow_closed agile_arrow_container">
<p title="Use one of our many templates as a starting point for your report or chart." id="headerTemplates" class="agile_arrow_title"><b>Templates</b></p>
<div style="display:none;" id="templates_section"></div>
</div>
<div style="display:none;" id="optionsContainer" class="agile_arrow_closed agile_arrow_container">
<p title="Click to change options.
To remember this custom report: click 'Query', change the tab below if needed, then make a Chrome bookmark." id="headerOptions" class="agile_arrow_title"><b>Options <span style="color:darkgray;">(click)</span></b></p>
<div style="display:none;" id="report_options_section">
<div><i>Click 'Query' after making changes.</i></div>
<table>
<tr>
<td valign="top" style="padding-right:3em;min-width:30em;">
<div>
<button id="saveReport" style="margin-top:0.5em;margin-bottom:0.5em;">Bookmark report</button>
</div>
<div class="report_options_item" title="Check to prevent cropping text in results.">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkNoCrop" />
<label class="agile_unselectable" for="checkNoCrop">No Crop (show full contents)</label>
</div>
<div class="report_options_item" title="Check to exclude S/E from cards with partial or no estimates when filtering by date.
If checked, the report and chart will only include cards with a first estimate entered in the filtered date range.
Not checking this option can produce unrealistic/negative E and R values when using date filters.
Do not check this option if you are only looking at Spent or card counts.">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkNoPartialE" />
<label class="agile_unselectable" for="checkNoPartialE">Exclude cards with partial or no <b>E</b> in the "Since" range</label>
</div>
<div class="report_options_item" title="Check to not generate charts, which can speed-up huge reports.">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkNoCharts" />
<label class="agile_unselectable" for="checkNoCharts">No Charts</label>
</div>
<div class="report_options_item">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkNoBracketNotes" />
<label class="agile_unselectable" for="checkNoBracketNotes">Remove all [bracket text] from notes in the Report tab</label>
</div>
<div class="report_options_item">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkNoSystemNumberFormat" />
<label class="agile_unselectable" for="checkNoSystemNumberFormat">Ignore my system's regional number format</label>
</div>
<div class="report_options_item" title="Card numbers are unique within a board and are assigned to cards in order of creation starting from '1'.
After clicking 'Query' try sorting by board then shift-click the card number column.">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkOutputCardIdShort" />
<label class="agile_unselectable" for="checkOutputCardIdShort">Include card number</label>
</div>
<input style="display:none;" class="agile_report_checkbox" type="checkbox" value="checked" id="checkHideAnnotationTexts" />
<input style="display:none;" class="agile_report_checkbox" type="checkbox" value="checked" id="checkHideZoomArea" />
<div class="report_options_item" title="The card 'shortLink' appears in a card URL as trello.com/c/shortLink/...">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkOutputCardShortLink" />
<label class="agile_unselectable" for="checkOutputCardShortLink">Include card shortLink</label>
</div>
<div class="report_options_item" title="The board 'shortLink' appears in a board URL as trello.com/b/shortLink/...">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkOutputBoardShortLink" />
<label class="agile_unselectable" for="checkOutputBoardShortLink">Include board shortLink</label>
</div>
</td>
<td valign="top">
<div id="labelOptionsProOnly" class="report_options_item" style="padding-top:.8em;"><a href="http://www.plusfortrello.com/p/plus-for-trello-pro-version.html" target="_blank">"Pro" version</a> only:</div>
<div class="report_options_item">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkAddCustomFields" />
<label class="agile_unselectable" for="checkAddCustomFields">Include Trello custom fields</label>
</div>
<div class="report_options_item">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkAddMembers" />
<label class="agile_unselectable" for="checkAddMembers">Include Trello card members</label>
</div>
<div class="report_options_item" title="Check if you paste to an app that does not fully support html colors (like Excel)">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkNoLabelColors" />
<label class="agile_unselectable" for="checkNoLabelColors">No color in labels in the Report tab</label>
</div>
<div class="report_options_item">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkSyncBeforeQuery" />
<label class="agile_unselectable" for="checkSyncBeforeQuery">Sync before doing the query</label>
</div>
<div class="report_options_item" title="Download report as CSV or Excel.">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkOutputReport" />
<label class="agile_unselectable" for="checkOutputReport">Download report as </label>
<select id="outputFormat">
<option value="csv">CSV (text)</option>
<option value="xls">XLS (Excel)</option>
</select>
<span id="noteExportFormat"></span>
</div>
<div class="report_options_item" style="width:40em;">
<input class="agile_report_checkbox" type="checkbox" value="checked" id="checkCustomColumns" />
<label class="agile_unselectable" for="checkCustomColumns">Output custom columns</label>
<div id="section_customColumns" style="display:none;margin-left:1.2em;">
<div><i>Drag to re-order.</i></div>
<select multiple="multiple" title="Pick columns..." id="selectAllColumns">
/* https://docs.google.com/a/plusfortrello.com/spreadsheets/d/1ECujO3YYTa3akMdnCrQ5ywgWnqybJDvXnVLwxZ2tT-M/edit?usp=sharing */
<option value="archived">Archived</option>
<option value="board">Board</option>
<option value="boardShortLink">Board shortLink</option>
<option value="card">Card</option>
<option value="cardNumber" title="Card numbers are unique within a board and are assigned to cards in order of creation starting from '1'.
After clicking 'Query' try sorting by board then shift-click the card number column.">
Card #
</option>
<option value="cardCount">Card count</option>
<option value="cardShortLink">Card shortLink</option>
<option value="dateCreated">Created date</option>
<option value="dateString">Date</option>
<option value="deleted">Deleted</option>
<option value="dateDue">Due date</option>
<option value="e">E</option>
<option value="e1st">E 1ˢᵗ</option>
<option value="eType">E. type</option>
<option value="hashtagFirst">Hashtag1</option>
<option value="keyword">Keyword</option>
<option value="labels">Labels</option>
<option value="nameList">List</option>
<option value="members">Members</option>
<option value="month">Month</option>
<option value="note">Note</option>
<option value="r">R</option>
<option value="s">S</option>
<option value="team">Team</option>
<option value="user">User</option>
<option value="week">Week</option>
</select>
</div>
</div>
</td>
</tr>
</table>
</div>
</div>
<div id="tabs" style="background: #E8EBEE;padding:0px;">
<div class="agile_tabselector_list" style="background: white;">
<table border="0" style="border-spacing: 0;" cellpadding="5">
<tr>
<td class="agile_tab_first">
<a href="#tabs-0" class="agile_report_tabselector">Report</a>
</td>
<td class="agile_tab_rest agile_tab_pivot">
<a href="#tabs-1" class="agile_report_tabselector">Spent By User</a>
</td>
<td class="agile_tab_rest agile_tab_pivot">
<a href="#tabs-2" class="agile_report_tabselector">Spent By Board</a>
</td>
<td class="agile_tab_rest agile_tab_chart">
<a href="#tabs-3" class="agile_report_tabselector">Chart</a>
</td>
<td style="width:100%" class="agile_tab_dummyLast"></td>
</tr>
</table>
</div>
<div id="tabs-0" style="display:none;padding-top:6px;" class="agile_report_container agile_report_tab"></div>
<div id="tabs-1" style="display: none;" class="agile_report_tab">
<div class="agile_format_container" title="To remove colors, pick 'No format or leave fields blank.
Note: current week always ignores 'under' format.">
<span>under </span>
<input class="agile_format_under" type="number" />
<input class="agile_colorpicker agile_colorpicker_colorUnder" type="color" title="Change color" value="#E8EBEE" />
<span style="margin-left:15px;">over </span>
<input class="agile_format_over" type="number" />
<input class="agile_colorpicker agile_colorpicker_colorOver" type="color" title="Change color" value="#E8EBEE" />
<select class="agile_report_optionsFormat" style="margin-left: 15px;">
<option value="smooth" title="Smooth coloring. Note: current week always ignores 'under' format.">Smooth format</option>
<option value="strict" title="Exact coloring. Note: current week always ignores 'under' format.">Strict format</option>
<option value="off" title="No coloring.">No format</option>
</select>
<img class="agile_drilldown_select agile_fixed" />
</div>
<div class="agile_report_container_byUser agile_report_containerScroll" style="overflow: auto;"></div>
</div>
<div id="tabs-2" style="display: none;" class="agile_report_tab">
<div class="agile_format_container" title="To remove colors, pick 'No format or leave fields blank.
Note: current week always ignores 'under' format.">
<span>under </span>
<input class="agile_format_under" type="number" />
<input class="agile_colorpicker agile_colorpicker_colorUnder" type="color" title="Change color" value="#E8EBEE" />
<span style="margin-left:15px;">over </span>
<input class="agile_format_over" type="number" />
<input class="agile_colorpicker agile_colorpicker_colorOver" type="color" title="Change color" value="#E8EBEE" />
<select class="agile_report_optionsFormat" style="margin-left: 15px;">
<option value="smooth" title="Smooth coloring. Note: current week always ignores 'under' format.">Smooth format</option>
<option value="strict" title="Exact coloring. Note: current week always ignores 'under' format.">Strict format</option>
<option value="off" title="No coloring.">No format</option>
</select>
<img class="agile_drilldown_select" />
</div>
<div class="agile_report_container_byBoard agile_report_containerScroll" style="overflow: auto;"></div>
</div>
<div id="tabs-3" style="display:none;padding-left:6px;padding-right:6px;padding-top:6px;margin-bottom:1em;" class="agile_report_tab">
<div style="min-height:1.5em;margin-top:1em;">
<select id="chartView" style="margin-bottom:1em;">
<option value="s">Spent</option>
<option value="e">Estimate</option>
<option value="r">Remaining</option>
<option value="ser">Spent & Remaining. E=S+R</option>
<option value="e1vse">E 1ˢᵗ versus E</option>
<option value="echange">E change</option>
<option value="burndown">S.E.R. Burndown</option>
<option value="cardcount">Card count</option>
</select><span id="stackByPre" style="display:none;">  Stack by </span>
<select id="stackBy" style="display:none;margin-bottom:1em;">
<option value="">None</option>
<option value="user">S/E user</option>
<option value="idTeamH">team</option>
<option value="idBoardH">board</option>
<option value="idCardH">card</option>
<option value="nameList">list</option>
<option value="hashtagFirst">hashtags</option>
<option value="labels">labels</option>
<option value="keyword">keyword</option>
<option value="comment">S/E note</option>
<option value="month">month</option>
<option value="week">week</option>
<option value="dateString">date</option>
</select>
<div style="white-space:nowrap;display:inline-block;margin-bottom:1em;" title="Uncheck to use a transparent background">
<input style="margin-left:2em;" class="agile_report_checkbox" type="checkbox" value="checked" id="checkBGColorChart" />
<label class="agile_unselectable" for="checkBGColorChart">Background: </label>
</div><input id="colorChartBackground" class="agile_colorpicker" type="color" value="#FFFFFF" title="Change color"/>
<div style="white-space:nowrap;display:inline-block;margin-bottom:1em;" class="report_options_item" id="spancheckNoColorsChart" title="Check to use white for stacks with value or gray otherwise.">
<input class="agile_report_checkbox" style="margin-left:2em;" type="checkbox" value="checked" id="checkNoColorsChart" />
<label class="agile_unselectable" for="checkNoColorsChart">No bar colors</label>
</div>
<span class="report_options_item" id="spanChartHeight" style="display:none;margin-left:2em;white-space:nowrap;" title="Control the bar height. If its too small, bar labels wont show.">
−<input style="height:0.6em;" type="range" value="0" step="1" id="heightZoomChart" min="-10" max="10" list="ticksChart" />+
<datalist id="ticksChart">
<option>0</option>
</datalist>
<label class="agile_unselectable" for="heightZoomChart">Bar height</label>
</span>
<img class="agile_drilldown_select"/>
</div>
<div id="chartMessage" style="margin-bottom:1em;"></div>
<div>
<div class="agile_report_containerScroll" style="overflow: auto;">
<div id="tooltipChart" class="qtip-dark chart-tooltip-custom" style="display:none;z-index: 2147483600"></div>
<div id="chartPrintContainer" style="display:block;padding-left:1em;padding-right:2em;padding-bottom:1em;padding-top:1em;">
<div id="chart" style="display:block;overflow:hidden;"></div>
<div id="labelGetPro" style="font-size:90%;text-align: center;display:none;margin-top:3em;cursor:pointer !important;color:#838C91;">Use our Pro version! Click for more.</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div id="reportBottomMessage" style="display:none;"></div>
</body>
</html>