Versions Compared

Key

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

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

  • Create a dashboard with multiple elements
  • Apply filters on dashboard charts
  • Apply sort orders on dashboard grids

...

  • In the left-hand sidebar in PhixFlow, press Image Removed - Show the list of dashboards

A list of all dashboards configured in this installation of PhixFlow will be shown.

  • Press Image Removed - Add a new item to create a new dashboard
  • When the dashboard details form appears, set Name to Debt Overview
  • Leave the Owner field blank – it will default to you (Train)
  • Tick the Public flag
  • Leave All Users Can View Data ticked
  • Leave Open Maximised unticked
  • Press Image Removed

A new blank dashboard will appear.

...

Create a dashboard with multiple elements

The following video illustrates how to create a dashboard with multiple elements:

Widget Connector
width900
urlhttps://www.youtube.com/watch?v=dSiXtpdj5t4
height500

To recap the steps in the video:

  1. In the repository browser, find Image Added - Dashboards
  2. Press  Image Added Add Dashboard
  3. Set the dashboard name to Debt Overview
  4. Press Image Added

Create the dashboard by using some stream views you created earlier, and by creating a new view:

  1. Open the configuration form for the stream Overall Debt Levels
  2. Drag the view Debt levels by payment means onto the dashboard pane
  3. Right click on the chart Debt levels by payment means in the dashboard and select Dashboard Options → Add Horizontal Bar
  4. Drag Debt levels by payment means 2 into the space
  5. Right click on the chart Debt levels by payment means in the dashboard and select Dashboard Options → Add Vertical Bar
  6. Drag

...

  1. the icon from the stream configuration form for Overall Debt Levels onto the space
  2. Choose view type Grid, and drag on all attributes from the stream to create the new view
  3. Go into App mode to see the results

Remove dashboard elements

  1. Open the

...

  • Drag Debt levels by payment means into the space on your dashboard
  • Press Image Removed - Save and lock the form layout

...

  1. dashboard Debt Overview

...

You decide that you want to see, instead of Debt levels by payment means 2, two versions of Debt levels by payment means – one with all records, one with only records for the last 40 days.
You first need to remove Debt levels by payment means 2:

  • Click in the banner of Debt levels by payment means 2 in the dashboard
  • Press Image Removed - Show additional buttons
  • Press Image Removed - Remove this item from the dashboard

...

  1. Right click on the view Overall Debt Levels_1 and select Dashboard Options → Remove Element from Dashboard
Note

Removing a dashboard element only removes the view from the dashboard, it does not delete the view.

Add view

Since we have only removed the dashboard element, the view we created still exists. We will add it back into the dashboard:

  1. Open the stream configuration form for Overall Debt Levels
  2. Find the view Overall Debt Levels_1, and drag it into the empty space in your dashboard
  3. Go into App mode - you should see that the dashboard is the same as before

Set dashboard to maximise on opening

Set your dashboard to that it automatically maximises when it is opened:

...

  1. Right click on any view in the dashboard and go to Dashboard Options → Show Dashboard Details
  2. In the dashboard configuration form, tick Open Maximised
  3. Close and open the dashboard, it will now be maximised

...

Apply filters on dashboards

You will now filter one of the views Debt levels by payment means to show only the last 40 days:

...

  1. Right click on the view Debt levels by payment means in

...

  • Tick the flag Use Custom Default Filter
  • Select the filter Last 40 days
  • Press Image Removed - Apply
  • Press Image Removed - Close

...

  1. your dashboard
  2. From the context menu, select Dashboard Options → Show Dashboard Details.
    PhixFlow displays the configuration form for the dashboard. In the form:
  3. Go to the Dashboard Elements section. 
    The table of elements has a lot of columns. Use the scroll bar to view them. If you want to see more of the column headings, you can drag the column dividers.
  4. In the table of elements, double click Debt levels by payment means
    PhixFlow displays the configuration form for this dashboard element
    •  In the Data Retrieval Options section, select the Use Custom Default Filter box
    • In the Default Filter drop-down list, select Last 40 days
    • Press Image Added to save your changes and close the dashboard element form.
  5. PhixFlow has updated Dashboard Elements table with the new information.

    • Image Added
  6. Press Image Added to save your changes to the dashboard and close form.
  7. Now check the result of the filter

Using background filters

Over the next two exercises you will create a dashboard that supports investigation into debt issues. First, you will create a view with a background filter:

  1. Open the configuration form for the view Overall Debt Levels

...


  1. You can do this directly from the stream configuration form for Overall Debt Levels by double-clicking on the view
    • In the Basic Settings section, set the Background Filter to Last 40 days
    • Save your changes to the view
  2. Create a new dashboard, called Debt Investigation
    • Drag the view Overall Debt Levels onto it
    • You will see that the data

...

    • has the Last 40 days

...

    •  filter applied.
      The chart on the left shows the filtered data. The chart on the right shows the unfiltered data.
      Image Added    Image Added  
  1. In the dashboard, press and add a new filter:
    • Name: Cash Only
    • Conditions: PaymentMeans equals CASH
  2. The resulting data set will contain records with PaymentMeans = CASH and within the last 40 days (34 records showing)

To verify this, open the Default View on the Stream stream Overall Debt Levels and apply the Cash Only filter; all CASH rows will be shown (100 records)

A background filter will always be applied – in addition to any other filter applied to the view. Once a background filter is applied on a view, it is not possible to see the data without this filter. In this way a background

filters differ

filter differs from a default filter – default filters can be overridden

(or even removed) simply by selecting a different filter.

...

by users if they simply select a different filter, or even clear the filter entirely.


A background filter can be set on a view, as in this exercise, or in the dashboard element properties

of

for the view on a dashboard

(press Image Removed on the view in the dashboard)

.
When you set up the view assess whether you will always want the background filter to apply in all circumstances; or whether the background filter needed will vary across different dashboards.

...

...

Using prompt for value filters

To complete the dashboard for investigating debt issues, you will now create a filter that will allow users to enter a value in a pop up form:to display one of the types of payment (cash, direct debit or cheque). To do this you will set the filter to prompt for a value.

Step 1  Create the filter

  1. In the workspace, open the  Debt Investigation dashboard.
  2. Add a filter to

...

  1. the dashboard Debt Investigation:
    • Name: select Payment Means
    • Conditions: 
      • Where ALL the following are true
      • PaymentMeans equals _prompt.PaymentMeans
      • Press the ABC button - this will now say fx

...

    • Press Image Added to save your changes.
  1. Creating the filter also applies it, so in the dashboard, PhixFlow displays a box prompting you to enter a value

...

  1. .
  2. Enter CHQ and press Image Added.
    The prompt is case-sensitive, so make sure you enter capital letters.
  3. The data will refresh to show

...

  1. one blue data line for cheques (34 records

...

  1. ).

Step 2  Apply the filter by default

Anyone using this dashboard can now apply the select Payment Means filter. However, we want PhixFlow to automatically use this filter and prompt a user to enter a payment means, e.g. CHQ, CASH or DD.

  1. In the workspace, open the  Debt Investigation dashboard.
  2. Right-click the dashboard  and select Unlock the layout.
  3. Right-click the dashboard again and select Image AddedShow the Stream View Configuration.
    PhixFlow opens the stream view configuration form for Overall Debt Levels:
    • In the Basic settings section, in the Default Filter drop-down list, select the option select Payment Means.
    • Press Image Added to save your changes.
  4. In the workspace, PhixFlow displays the prompt.

Step 3  Check the setting works

  1. In the workspace, close the dashboard.
  2. In the repository list, find the  Debt Investigation dashboard and double-click the name to open its configuration form.
  3. In the form toolbar, click Image Added Display to open the dashboard in the workspace.
  4. The dashboard opens and PhixFlow opens the filter prompt.

Every time that this dashboard is opened the user will be is prompted to enter a value. If you enter a value and want to change this, you can re-select the filter and you will be prompted to enter a new valueTo change the filtered data,  CHQ, CASH or DD click the filter icon to redisplay the prompt.