By the end of this exercise you will be able to:

• Understand the components of a view
• Create a grid view

Finding Tables and Table Data

1. Open the  Analysis Model list.
2. Find and open the model Screens and Forms 01-08: Views, filters and screens
3. In the model place your mouse over the table Overall Debt Levels
4. A hover menu will appear, press  Show view and select Default View.
5. The data contained in the table will appear.

Create New View

You will create a new grid view to show the data in the table in a table format. This is illustrated by the following video.

Important terminology changes: Dashboards are now referred to as Screens, and Streams are now referred to as Tables.

To recap, the steps in the video were:

1. Create Screen:
   
   1. Click on Screen from the application home screen.
   2. Click  Add New.
   3. Set the screen name to Overall Debt Levels.
   4. Select a Template e.g. Tile No Button.
   5. Click the Create Screen button.
   6. A new screen will appear.
2. Now create a new view on the screen:
   1. Use the tabs to navigate back to the analysis model Screens and Forms 01-08: Views, filters and screens.
   2. Double click on the table Overall debt levels.
   3.  Pin this table's properties tab.
   4. Using the tabs, select the screen you just created (Overall Debt Levels) to bring this back to the front.
   5. Drag the table icon  Table in the top left hand corner (of the table config form you pinned) onto the screen.
   6. Choose to display the attributes as a  Grid view.
   7. This creates a view on the screen, and the properties tab for the view opens on the right.
   8. From the attributes popup that appears drag the attributes you want (in this case, all of them) from the list onto the header of the view in the screen.

You can also see your new view in the list of views for the table:

1. Hover over the table Overall Debt Levels in the model.
2. From the hover menu press  Show view and select Overall Debt Levels.
   

Editing a View

1. Open the screen Overall Debt Levels.
2. Right click on the grid in the screen, select  Show view
3. You can edit details of the view in the configuration form, but there are a number of changes you can make directly to the view in the screen:

Re-order Columns

To re-order columns:

1. Grab a column heading
2. Drag it, drop it in a new position.

Freeze Rows

You can freeze a number of columns.

First prepare some data:

1. Open the model Screens and Forms 11-13. Actions to update, insert, delete
2. Run analysis on the table Wisteria Books Inventory - this will load data into the table.
3. Create a new view:
   1. Create a new screen: Wisteria Books Inventory
   2. Drag the table Wisteria Books Inventory onto the screen
   3. Select Grid view
   4. Add all attributes
4. Widen the columns so that you can see all (or most) of the text in each column - eventually you will see a horizontal scroll bar appear at the bottom of the view.

Freeze a column:

1. Freeze the second column (this should be Subject): right-click on the column heading and select Freeze column.
2. Slide the horizontal scroll bar - you will see the first 2 columns are frozen.

Set Width

You can fix the width of a column. By default, columns are flex, which means they will consume the available space. To fix a column width:

1. Grab the right hand edge of a column heading and move it to set the width.
2. Click on  Lock in the toolbar.
3. Maximise the view - you will see that the set column stays the same size, while the remaining columns flex.
4. Right click on your screen and select  Unlock to continue editing your screen.

Set Flex

If you fix the width of a column, you can return it to being a flex column:

1. Right-click on a column heading.
2. Select Set flex column.

Column Filtering

As well as building permanent filters (you will do this in the next exercise), column filters (sometimes called quick filters) are available to you and the users you are creating this view for. To use a column filter:

1. Hover over a column heading
2. A  Filter.
3. You can select operators and enter value to filter on values in that column.
4. You can add clauses to this filter.
5. You can additionally filter on other columns, and these filter will apply together to further filter the data.

Column Sorting

As well as building permanent sort orders (you will do this in a future exercise), you can apply a column sort:

1. Right click on a column heading in the table view
2. Select Sort Ascending or Sort Descending