In Reporting > Query Builder, the right-hand Columns panel controls which columns appear in the results and the order they appear in.
Reordering columns
In the Columns panel, each column row has a drag handle (the three horizontal lines) on its left side. Click and drag a row's handle up or down to change where that column appears in the results table.
Adding or removing columns
To remove a single column, click the X icon at the right end of the column's row. The row disappears immediately.
To add columns — or to make a larger set of changes in one place — open the menu in the top-right corner of the Columns panel. It has two options:
Choose columns
Opens a side panel with every available column, grouped by category (General, Additional, Contact, and so on) and matching the categories in the Filters panel. Use the checkboxes to add or remove columns. Helpful controls inside this panel:
Search for columns below… — type to narrow the list to matching column names.
show selections only — toggles the view to display just the columns currently checked.
check all / uncheck all — apply to the category they appear under, not the whole list.
Close the panel when done. Selections appear immediately in the Columns panel in the order they were checked. Drag rows to rearrange them.
Reset columns
Restores the default set of columns: First Name, Last Name, Gender, Birthday, Age, Campus, Primary Email, and Primary Phone. Any custom columns will be added.
Tip: Save the column selections to a query so they're ready next time. Click Save as… at the top of the query builder to store the current filters, columns, and sorting as a named saved query.
Other Helpful Articles