Opened 6 years ago

Last modified 6 years ago

#249 new Enhancement

Transpose row and column in query results

Reported by: Maria Baron Owned by:
Priority: -Low Milestone: Unassigned
Component: View-App Version: Parking Lot
Severity: Unknown Keywords: query result table
Cc:

Description

Just an idea...

If a query user chooses, for example, 3 years of data as the row variable and 12 counties as the column variable, the result table is short and wide and the user needs to go back and choose county as the row and year as the column variable to get a table that is easier to read and looks decent.

Can a "Transpose" button be added to the query result page so a user could flip the table without going back to the builder?

Missouri's MICA system does this with their "Rotate" link, so there might be some open source code there that could make this a simple enhancement. (Wishful thinking, I'm sure.) See attachments for before and after views of the MICA Rotate function.

Attachments (2)

RotateBefore.png (83.1 KB) - added by Maria Baron 6 years ago.
RotateAfter.png (20.1 KB) - added by Maria Baron 6 years ago.

Download all attachments as: .zip

Change History (4)

Changed 6 years ago by Maria Baron

Attachment: RotateBefore.png added

Changed 6 years ago by Maria Baron

Attachment: RotateAfter.png added

comment:1 Changed 6 years ago by Maria Baron

Keywords: query result table added

comment:2 Changed 6 years ago by kathie

Version: UnknownParking Lot
Note: See TracTickets for help on using tickets.