Group resulting rows to the level of detail you need.
Each resulting row will show the sum of its grouped numeric fields (counts, S/E/R and custom fields).
Grouping affects the Report and Chart tabs.
When grouping by 'S/E rows', cards without S/E do not appear in the report.
'User' refers to those with S/E, not card members.
Group by
Pick a pivot to change the columns in the 'Spent by ...' tabs.
If you do not need to pivot, using 'Year' will make the report a little faster.
Pivot by
Order resulting rows. Also click report headers to change order (SHIFT-click for multi-column).
When the card has S/E rows, the row date is based on S/E rows.
Otherwise its the date of the card's last create, move or rename.
Special orders:
R (non-zero)
Special 'Remaining' report. Shows only rows with non-zero R.
This order makes sense with filter 'since: All dates' and group by card,list,board,team or user.
To show S/E columns, group by Card-User.
To sort by R without this special behavior, order by something else, query, then click the R column header.
Due date
only shows cards with a due date, and only works when grouping by Card or Card-User.
List position
orders first by board name (descending) then by list position in each Trello board.
Order by
Filter by date.
To pick start or end dates, pick 'Advanced'.
When the card has S/E rows, the date in that report row is based on S/E rows.
Otherwise it uses the date of the card's last create, move or rename.
Since
Valid formats:
2014
2014-W12
Using a week filter only shows results that have S/E.
Week start
Valid formats:
2014
2014-W15
Using a week filter only shows results that have S/E.
To find NOT containing, start with ! Partially supports AND/OR:
When using OR, no term can be negated: label1 OR label2 OR label3
When using AND, all terms must be negated: !label1 AND !label2 AND !label3
If you need a more complex filter, export the report results to a spreadsheet using 'Copy'.
Labels sync note: 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.
To force fresh card label results in those cases click on sync from the Chrome Plus menu or the top weekly report in Trello.