Versions Compared

Version Old Version 4 New Version Current
Changes made by

Chris Welford

Chris Welford

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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  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 
  • Similarly, set the grid width for Synopsis to 400
  • Press  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 Width On Form (pixels) to 300
    • Set Height On Form (pixels) to 200
    • Press Image Removed
    • Notice that when you update these values the Size On Form box changes to indicate the size that the field will now have on a form
  • Press Image Removed in the main view configuration form to save your changes
  • Double-click on any row of data in the view
  • In the record details form you will see the Synopsis field resized to the new settings

...

  • Open a record details form: double-click on any row of data in the view Book List
  • Press Image Removed - Modify the form layout
  • Grab the corner of the form and expand it
  • Grab one of the field names and drag the field to a new position on the form
  • Update the name of the details form to Book Details
  • Press Image Removed - Save and lock the form layout
  • This will update the layout of the details form for any record – open the details for another record by double-clicking it
  • You will see the details form pop up with the new layout

...

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 
  • Press  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 
  • Press  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:
Code Block
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