...

Changes row colour

• Open the model Dashboards and Forms 09, 10: Linked Views and presentation that you created in the previous exercise
• Open the configuration form for the view Book List on the Stream stream Book List
• In the list of Stream View Attributes double - click on Publisher
  • Tick the flag Changes Row Colour
  • Press Press Image Modified
• Press Image Removed Press Image Added in the main view configuration form to save your changes
• Open the view and sort by Publisher – simply right click on the heading of the Publisher column and select Sort Ascending
• You will now see that the colour of the rows changes when the Publisher changes

...

Grid column width

• Open the configuration form for the view Book List on the Stream stream Book List
  • Remember you can right - click on any data row anywhere on the view on the dashboard and select Show the Stream View Configuration
• In the list of Stream View Attributes double - click on Publisher
  • Set the field Grid Default Width (pixels) to 150
  • Press Image RemovedPress Image Added
• Similarly, set the grid width for Synopsis to 400
• Press Image Removed Press Image Added in the main view configuration form to save your changes
• Either open the view – or if you already have the view open, press Refresh
• You will now see the data displayed with the column widths you have set

...

• Double-click on any row of data in the view Book List – a form with the details of the record will pop up
• Close this detail view
• Open the configuration form for the view
In the list of Stream View Attributes double-click on Synopsis

Set

...

field

...

alias

• Open the configuration form for the view Book List on the Stream stream Book List
• In the list of Stream View Attributes double - click on Subject
  • Set the Alias Under Basic Settings, set the Name to SubjectOfBook
  • Press Image Removed
  Press Image Removed
  • Press Image Added
• Press Image Added in the main view configuration form to save your changes
• Either open the view – or if you already have the view open, press Refresh
• You will see the new view attribute name appear as the column heading in the view

...

Hover text for descriptions

• Open the configuration form for the view Book List on the Stream stream Book List
• In the list of Stream View Attributes double - click on Synopsis
  • Set the Alias Name to Description
  • Press Image Removed
  Press Image Removed
  • Press Image Added
• Press Image Added in the main view configuration form to save your changes
• Either open the view – or if you already have the view open, press Refresh
• Hover over one of the book descriptions – you will see the text pop up in a hover box

...

• Add an attribute to the Stream Book List:
• Name: gridRowColour
• Type: String
• Length: 50
Expression:

if (_out.Publisher == "Humbolt", "red", "aqua")

• Re-load the file and run the stream to populate the new attribute:
  • Open the file browser from the file collector Book List
  • Navigate to the directory …\inputData\Books
  • Load the file BookList.xlsx
  • Run the stream Book List
• Create a new view on the Stream BookList
  • Type: Grid
  • Name: Book List – Publisher by Colour
  • Attributes: add all attributes to the view
  • Press Image Removed to save your changes

Open the new view – you will see records for the publisher Humbolt highlighted in red, other rows shown in light blue.

Formatting numbers

Open the dashboard Debt Investigation (you created this in exercise 2). You will format the numbers that appear on this dashboard:

• Open the configuration form for the view Overall Debt Levels
• Open the configuration form for the view attribute DebtLevel:
  • Set Decimal Places to 23
  • Save your changes to the view attribute
• Save your changes to the view
• Refresh the dashboard – you will now see the debt level reported with 2 decimal places

Formatting dates on pivot views

Open the model Dashboards and Forms 01-08: Views, filters and dashboards (you created this in the Introduction to Modelling Course; if this is not available, open Dashboards and Forms 01-08: Views, filters and dashboards R).

• Go to the stream Overall Debt Levels
• Open the configuration form for the pivot view Debt levels by payment method and date
• Make PaymentMeans a Row Attribute, and CalculationDate a Column Attribute
• Double click on CalculationDate in the field Column Attribute to open the view attribute configuration form:
  • Set Date/Time Format to yyyy-MMM-dd
  • Save your changes to the view attribute
• Save your changes to the view
• Open the view to see the dates as column headings, formatted as you have specified above