Follow

How to do loads of stuff with the grids

The grids are pretty powerful. There is a lot you can do with them.

Column control

Change order of columns To move a column, simply "left click and hold" on the column header and drag the column to where you want it.
Hide/Add columns

First click on the "Column Chooser" icon Column_chooser.JPGwhich should be at the top right of the screen. This will then open a pop up screen.  There may already be some hidden columns listed her.

To remove a column, drag the column into the pop up screen.

To add a column, drag it from the "Column chooser" to where you want it

Resize column In the column heading row, hover your mouse over the right hand side border and the pointer will change to a resize icon. Left click and resize the column.
Pin/Fix a column to the left or right

Right click on the column heading and you will see a few options, one of which is Fix either to the left or the right. Simply click on the one you want and the column will be moved to the left or right and pinned there. 

To undo, simply right click and choose Unfix

 

Sorting and Filtering

Sort by a single column

Simply left click on the column heading and the grid will be sorted by that column, e.g A-Z. Click again to sort in the other direction, e.g Z-A.

If you right click on a column heading, you will see extra options.  

Sort by multiple columns To sort by multiple columns when using mouse and desktop, simply shift and left click on each column in turn.  When you next click on a columng heading, the multi column sorting will be cleared. 
 Filter

Click on the Filter icon in the top row and apply your filtering conditions. Depending on the data, you will be presented with multiple filtering functions, e.g date functions for dates and text options for text.

You can apply filters across multiple columns.

Clear filters

To clear a filter in one column, hover on the filter icon and click on "Select All". 

To clear all filters, click on the Clear button top right. 

 

Search

Global search 

To search the whole grid, use the global search field at the top right of the page.

This search will only search visible columns. Hidden columns are not included in the search.

Search within a column To search within a column, use the search field under the Column header. 

 

Grouping

Grouping is very powerful and incredibly easy. Simply "left click and hold" and drag a column heading to the text "Drag a column header here to group by that column"at the top left of the table. You can drag multiple columns and you can reorder the column headings in this are to change the order in which the grid is grouped.

To Ungroup, simply drag the column header back down to the grid.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk