Versions Compared

Key

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

...

FieldDescription
NameThe name of the stream view.
Display TypeA number of chart types are available:
    • Grid: show stream data laid out in a table.
    • Pivot: show stream data laid out in a table, with data for values of one attribute broken out ('pivoted') into multiple columns.
    • Line Chart (category horizontal axis): plot line, or lines, representing quantities against a horizontal axis of 'categories'. The categories are printed along the horizontal axis, ordered alphanumerically.
    • Line Chart (numeric horizontal axis): plot line, or lines, representing quantities against a numerical horizontal axis.
    • Line Chart (times series horizontal axis): plot line, or lines, representing quantities against a date/time value - a stream attribute of type Date or Datetime.
    • Barchart: plot a quantity as a set of bars against a set of categories along the horizontal axis.
    • 3D Barchart: a 3D version of the standard barchart.
    • Stacked Barchart: a bar chart where multiple series/multiple attributes per category are displayed in a stacked form.
    • Pie Chart: show a quantity as a pie chart, grouped by a category.
    • Pie Chart: a 3D version of the standard pie chart.
    • Dial Chart: a red/amber/green chart showing a single value.

If display type is a chart and the user elects to output the chart to HTML (either via

a File Exporter

or from a chart

view)

, PhixFlow will output the chart to HTML as a picture (.PNG).

Excel Template

An excel template can be linked to the view to specify the format the chart data should be exported in.

The location that excel templates must be saved to is specified in the System Configuration.

Number of PeriodsNumber of processing periods from the stream to display on the chart. If a full set of data is generated in each period, then this will be 1. If the data is spread across processing periods in the stream - for example, each processing period only contains new data for that day, but we want to plot data across a number of days - then this number must be high enough to include all data of interest to show on a chart.
Background FilterAny filter on the stream can be selected as the background filter for this view. When the user opens this view the background filter is applied first and any other filter applied to the view (either specifically created/selected by the user or automatically applied as the default filter described above) acts in addition to the background filter.
Default FilterAny filter on the stream can be selected as the default filter for this view.
Default Sort OrderIf specified, the default order in which data should be displayed. See the Stream View Sort Order form.
All Users Can View DataIf checked, this specifies that all users can view this stream view by default (provided they have the basic privilege to view stream views). If this field is not checked, then access to the stream view is controlled by dropping user groups onto the stream's "User Groups" tab.
Default WidthThe default width of the Stream View. If empty, the View's width will be set to the system default value.
Default HeightThe default height of the Stream View. If empty, the View's height will be set to the system default value.
Form View

Check box to determine if this view is to be used as a Form View.

Values governing the appearance of charts are configured in the Chart Layout tab.

The following fields apply to Pivot views:

FieldDescription
Pivot Column Source

The pivot column source determines how the the values that are converted to Pivot Columns are generated:

View Data

The pivot column values are read from the value attribute in the data being viewed.

If the label attribute is specified, the label values corresponding to the value attribute values are used as pivot column headers.

The is the simplest way to derive the pivot column values, but does not allow any control of the order of values, or the ability to handle missing values e.g. when generating standard reports

Expression

The pivot column values are the result of an expression.

The expression must return either a list of values or a list of pairs of values (the values and corresponding labels). E.g.

['20150101', '20150201', '20150301']

or

[ [ '20150101', 'Jan'], [ '20150201', 'Jan'], [ '20150301', 'Jan'] ]

If no labels are provided, they are derived from the pivot values using the formatting options set on the Column attribute.

Pivot Column Expr

If Pivot Column Source == Expression, this expression must return either a list of values or a list of pairs of values (the values and corresponding labels). E.g.

['20150101', '20150201', '20150301']

or

[ [ '20150101', 'Jan'], [ '20150201', 'Jan'], [ '20150301', 'Jan'] ]

Row Attributes 
Maximum Pivot Columns 

Column attribute

 
Value Attribute 
Label Attribute 

 

The following fields apply to all graphs, that is, all display types other than Grid or Pivot:

FieldDescription
Default ResolutionSet the default resolution for the generated graph. Larger values will produce a more finely grained image, and equivalently smaller fonts, sometimes useful when using graphs containing a large amount of data. Smaller values will produce a bolder, less finely grained image, sometimes useful for producing a clearer graph when there is not much data to display.
Minimum ValueMinimum value along the vertical axis to be displayed. This value will be lowest point on the vertical axis if any value in the data plotted falls below this value. Otherwise, the graph will be automatically sized as normal.
Maximum ValueMaximum value along the vertical axis to be displayed. This value will be the highest point on the vertical axis if any value in the data plotted falls above this value. Otherwise, the graph will be automatically sized as normal.
Fixed ScaleIf fixed scale is turned on, the the maximum value and minimum value defined will always be used as the highest and lowest points on the vertical axis, regardless of the data plotted.
Horizontal Axis TitleThe label given to the horizontal axis.
Vertical Axis TitleThe label given to the vertical axis.
Include LegendWhen a series is used, if this is turned on then a box listing all lines shown, along with the corresponding values, is displayed on the graph.
Tick label angleThe orientation of the values displayed along the horizontal axis. Select a value from the drop down menu.
Show Horizontal GridlinesIf this is turned on, horizontal gridlines are displayed on the chart.
Show Vertical GridlinesIf this is turned on, vertical gridlines are displayed on the chart.
Show Values on ChartsIf this is turned on, then the y/data attribute values are also displayed on the chart for better clarity.

...

The following fields apply only to dial charts:<

FieldDescription
Major Tick IncrementThe incremental values at which major tick marks should be shown. Do not set too low for the minimum/maximum values specified otherwise there will be too many major ticks.
Minor Tick CountThe number of tick marks between each major tick.
First Band ColourThe colour of the first segment on the three coloured arc indicating different regions of the dial.
Second Band ColourThe colour of the second segment on the three coloured arc indicating different regions of the dial.
Third Band ColourThe colour of the third segment on the three coloured arc indicating different regions of the dial.
First Threshold ValueThe value at which the first band colour changes to the second band colour.
Second Threshold ValueThe value at which the second band colour changes to the third band colour.
Dial StyleArc or Circular.

...