180967 - csv reports swap rows/columns

Status: RESOLVED FIXED

(Bugzilla :: Reporting/Charting, defect)

Description

[Christian :Biesinger (don't email me, ping me on IRC)]

so I executed this query today:
http://bugzilla.mozilla.org/report.cgi?x_axis_field=&ctype=html&y_axis_field=assigned_to&z_axis_field=&query_format=report-table&short_desc_type=allwordssubstr&short_desc=&product=Browser&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&resolution=FIXED&emailassigned_to1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&votes=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&format=table&action=wrap&field0-0-0=noop&type0-0-0=noop&value0-0-0=
and got back a table with the first column being assignee, second bug count
(only FIXED bugs, browser component).

now, when I clicked the CSV Link on the result page, the rows and columns got
swapped, so that all the assignees were on the first line, the count on the
second one.

this was pretty unexpected...

Comment 1

[Christian :Biesinger (don't email me, ping me on IRC)]

urg I messed that up, let's fix the component.

Comment 2

[Gervase Markham [:gerv]]

The reason for this is that there's a special hack for tables. You see, if you
specify just one axis, that's the "x-axis". But for tables, people expect it to
be plotted as the y-axis (vertical). So, we swap things round. Obviously, we
appear to not be doing this for CSV.

I'll look into it.

Gerv

Comment 3

[Gervase Markham [:gerv]]

Fixed by checkin to bug 181182.

Gerv