...

Create a line chart (time series)

The best way to configure views is to add them to a dashboard first. Create a dashboard for this viewYou will create a line chart, plotted over time, of debt levels broken down by payment means. Creating a line chart is illustrated by the following video:

To recap on the steps in the video:

• In the repository browser, find - DashboardsRight click and select - Add Dashboard
• Set the dashboard name to Debt levels by payment means
• Click Apply to save your changes
• In the repository, navigate to Dashboards, and find the dashboard you just created (Debt levels by payment means)
• Right click on this and click Display to open your dashboard in a new window
• Open the model Dashboards and Forms 01-08: Views, filters and dashboards:
  • If you already have this open, use the PhixFlow task bar (grey bar at the bottom of the screen) to navigate back to the model
  • If this is not already open, in the repository, navigate to Analysis Models, find the model, right click and select Display
• From the model view, double click on the stream Overall debt levels

• Open the model Dashboards and Forms 01-08: Views, filters and dashboards
• Open the stream configuration form for Overall Debt Levels
• Go to the Views section

You will create a line chart, plotted over time, of debt levels broken down by payment means:

• Press Image Removed - Insert

• Set:

• Name: Debt levels by payment means

• Display Type: Line Chart (time)

• Press OK

• In the stream configuration form, navigate to the Views section
• Use the Phixflow task bar to reopen the dashboard Debt levels by payment means
• In the stream configuration form for Overall debt levels, find the view you created (line chart), and drag this on to the dashboard Debt levels by payment means
• Because you are in design mode, you will see a set of configuration fields

To complete the configuration:

• In the stream view configuration form, navigate to the Views panel
• Double click on the view you created (Debt Levels by Payment means) to open the stream view configuration form
• In the View Attributes panel, click on Image Removed- Show Stream Attributes
• Drag attributes from this list into configuration fields in the chart builder From the PhixFlow task bar, bring the dashboard Debt levels by payment means back to the front
• Drag the icon in the top left hand corner of the stream config form onto the dashboard
• Choose a Line Chart view
• This creates a stream view - configuration options for the stream view show in the dashboard; the configuration form for the stream view also pops up in the repository browser
• From the stream view configuration form, open the list of stream attributes
• Drag attributes into the configuration options on in the stream view as:

Notice that as you drag attributes across, they are added to the list of stream view attributes, with the appropriate role set. For DebtLevel (Y axis), the correct role is Datapoint.

...

Data Point.

To see the chart, go into App mode. To update the configuration again, go back into Design mode.

To complete the configuration, we will label the axes:

• In the dashboard, right click on the view and select Image Added Show the Stream View Configuration
• In the stream view configuration form
, navigate to Chart Layout, and update the following settings:

***

...

• :
  • Update the name of the view to Debt levels by payment means
  • Set the Display Type to Line Chart (time)
  • Enter the following settings:

• Press Image Modified
• To update the dashboard into display mode (from design mode), anywhere on the view in the dashboard:
  
  • Right click → Dashboard Options → Lock the layout
• You will now see you chart

To go back into design mode - that is, to see the chart builder - on the chart:

• Right click → Unlock the layout

...

• to save your changes

Go into App mode to see the chart.

Setting an upper limit

There is one data point in the data which is much greater than all the others, so movements in the levels of debt cannot be seen. Add a maximum value in the chart layout configuration to exclude this outlier and generate a more useful graph:

...

Now you will create a graph of the same data, but this time using a bar chart. Add a new view on the stream Overall Debt Levels:

Create a view with:

...

...

• Create a dashboard with Name: called Debt levels by payment means 2
• Click Apply to save your changes
• In the repository, navigate to Dashboards, and find the dashboard you just created (Debt levels by payment means 2)
• Right click on this and click Display
• 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 
• Double click on the stream Overall debt levels 
• In the stream view configuration form, navigate to the Views section
• Use the Phixflow task bar to reopen the dashboard Debt levels by payment means 2 
• In the stream configuration form for Overall debt levels, find the view you created (3D bar chart), and drag this on to the dashboard Drag the icon from the stream configuration form for Overall debt levels onto the dashboard
• Select the view type Barchart

• Drag attributes into the configuration options on in the stream view as:

  SERIES	PaymentMeans
  Y ATTRIBUTES	DebtLevel
  X ATTRIBUTE	CalculationDate

  
  

• Open the stream view configuration form
  • Update the name of the view to Debt levels by payment means 2
  Then complete the configuration using the chart builder and the stream view configuration view to update
  • Set the Display Type to 3D Barchart
  • Update the following settings:

...

SERIES

...

PaymentMeans

...

• Save your changes the new view, and stream view configuration form
• Go into App mode to view the results

The view looks very cluttered – but we will filter this later to make this more useful.

...