...

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

Finding Streams and Stream Data

1. Open the list of models
2. Find and open the model Dashboards and Forms 01-08: Views, filters and dashboards
3. In the model view place your pointer over the stream Overall Debt Levels
4. A hover menu will appear – press  Show the list of Stream Views and select Default View

The data contained in the stream will appear.

Create New

...

View

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

...

1. Create dashboard:
   
   1. In the repository, find Dashboards
   2. Right click and select Add Dashboard
   3. Set the dashboard name to Overall Debt Levels
   4. Click Apply to save your changes
   5. A new, empty dashboard will appear
2. Now create a new view on the dashboard:
   1. Use the Phixflow task bar (grey bar at the bottom of the screen) to navigate back to the model Dashboards and Forms 01-08: Views, filters and dashboards
   2. Double click on the stream Overall debt levels
   3. Again using the PhixFlow task bar, select the dashboard you just created (Overall Debt Levels) to bring this back to the front
   4. Drag the icon in the top left hand corner of the stream config form onto the dashboard
   5. Choose a Grid view
   6. This creates a stream view - the stream view shows on the dashboard, and the configuration form properties tab for the view opens in on the repositoryright
   7. From the stream view configuration form, open the list of stream attributes
   8. Drag the attributes you want (in this case, all of them) from the list onto the header of the stream view in the dashboard

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

1. Hover over the stream Overall Debt Levels in the model
2. From the hover menu press  Show the list of Stream Views and   and select Overall Debt Levels
   

Editing a

...

View

1. Open the dashboard Overall Debt Levels
2. Right click on the data in the dashboard, select Image Removed Show the Stream View Configuration

   Insert excerpt
   _view_show _view_show nopanel true

You can edit details of the view in the configuration form, but there are a number of change you can make directly to the view in the dashboard:

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.

...

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. To see this, maximise the dashboard - the columns widen to fit the overall size of the window. To fix a column width:

1. Grab the right hand edge of a column heading
2. Move it to set the width
3. Maximise the view - you will see that the set column stays the same size, while the remaining columns flex

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 symbol appears
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:

...