--- title: "Grids" slug: "grids" updated: 2022-08-23T15:51:12Z published: 2022-08-23T15:51:12Z canonical: "support.smarteru.com/grids" --- > ## Documentation Index > Fetch the complete documentation index at: https://support.smarteru.com/llms.txt > Use this file to discover all available pages before exploring further. # Grids Grids are used throughout SmarterU to display the output of the [Learning Plan](/v1/docs/learning-plan-report), [Training Cost](/v1/docs/training-cost-report), [Quiz Analysis](/v1/docs/quiz-analysis-report), and [Audit Log](/v1/docs/audit-log-report) reports. ![Interface gráfica do usuário, Aplicativo Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-au6if9gp.png) ## **Sorting a Grid's Contents** You may only sort on one column at a time. To sort a grid's contents: 1. Run the report. 2. Do one of the following: - Click the column header you would like to sort the results by. The first time you click a column header the results will be sorted in ascending order. Clicking the column header again sorts the results in descending order. - Click the ![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-ywrfi24s.png) beside the column header by which you would like to sort the results and select **Sort Ascending** or **Sort Descending**. ![Tabela Descrição gerada automaticamente com confiança média](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-bgfbgzap.png) An arrow displays beside the column header to indicate the sort order. ![Tabela Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-mcxxdx31.png) ## **Changing Columns Displayed** - Changing the columns displayed is not a permanent or saved change. The changed columns will only stay in effect while you are on the same page. - Changing the columns does not affected the [exported columns](/v1/docs/grids#exporting-a-grids-contents). To change the columns displayed in a grid: 1. Run the report. 2. Click the ![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-flkd6tle.png) in any column header in the grid. 3. From the menu, select **Columns**. ![Interface gráfica do usuário, Aplicativo Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-2nu9nyuc.png) 1. To include a column in the grid, check the checkbox beside the column name. To hide a column, uncheck the checkbox. ## **Filtering a Grid's Contents** Filtering enables you to specify criteria so that only those rows that meet your criteria are displayed in the grid. For example, you could apply a filter to the Learning Plans Report so that it only displays learning plans that contain the word "Sales". - Filters are not available for all columns. - You may apply filters to multiple columns. - The conditions that are available will vary based on the column. To filter a grid's contents: 1. Run the report. 2. Click the ![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-dfcztyq5.png) in the column you would like to apply a filter. 3. From the menu, select **Filter**. ![Interface gráfica do usuário, Aplicativo Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-oatuen9v.png) 1. Select the condition from the **Show Items With Values That** list. 2. Enter the value in the field. ![Interface gráfica do usuário, Aplicativo, Email Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-ravihumi.png) 1. If you would like to specify another filter: 1. Select [*And* or *Or*](/v1/docs/understanding-and-vs-or-filter) from the list. *And* includes a row if both filters are met; *Or* includes a row if either filter is met. 2. Select the condition from the list. 3. Enter the value in the field. 2. Click **Filter**. ## **Removing Filters** To remove filters from the grid: 1. Click the ![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-vtcd9h91.png) in the column you would like to remove a filter. 2. From the menu, select **Filter**. 3. Click **Clear**. ![Interface gráfica do usuário, Aplicativo, Email Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-ibb16qqj.png) ## **Exporting a Grid's Contents** If you've [sorted](/v1/docs/grids#sorting-a-grids-contents) or [filtered](/v1/docs/grids#filtering-a-grids-contents) the grid's contents, or [changed the columns displayed](/v1/docs/grids#changing-columns-displayed), those changes will not be reflected in the export. The export includes the all rows contained in the grid prior to the filter in the original sort order. To export the contents of a grid: 1. Display the dashboard or run the report. 2. Select one of the following: - **Export to CSV** - exports the columns that are visible in the grid. For the [Quiz Analysis Report](/v1/docs/quiz-analysis-report), the Export to CSV option exports [all available columns](/v1/docs/quiz-analysis-report-columns#available-columns) (including the ones displayed) for the report. - **Export to CSV (full)** - exports all report columns and all [user-related columns](/v1/docs/exporting-users). For the Quiz Analysis Report, a full export includes correct and incorrect answers. ![Interface gráfica do usuário, Aplicativo Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-beopdg0u.png) The Export Notification window displays. 1. In the **Send Email To** field, enter the email addresses of the users who should receive the link to the file. 2. **Click Confirm**. ## **Grouping a Grid's Contents** Grouping clusters the grid's contents using common values of a selected column. For example, you might want to group your report's results by Course Name to view sub-totals for each course. - You may only select text columns for grouping. - You may only group results by a single column. - Grouping is only available for the [Training Cost Report](/v1/docs/training-cost-report). To group a grid's contents: 1. Run the report. 2. Click the column header that you would like to use for grouping. 3. Drag the column header to the area above the grid. ![Tabela Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-2x0kied0.png) The contents are grouped by the selected column. ![Tabela Descrição gerada automaticamente](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/grids-image-hytunabg.png) ## Related - [Audit Log Report](/audit-log-report.md) - [Learning Plan Report](/learning-plan-report.md) - [Quiz Analysis Report](/quiz-analysis-report.md) - [Training Cost Report](/training-cost-report.md)