...
The view looks very cluttered – but we will filter this later to make this more useful.
Create
...
an
...
Name
...
Debt overview by payment means
...
Display Type
...
3D Pie Chart
...
DebtLevel
...
LABEL ATTRIBUTE
...
PaymentMeans
...
Show Legend
...
tick
...
Show Values on Charts
...
tick
...
aggregate grid view
Now you will create a grid view on the data in Overall Debt Levels, but to show aggregated totals by payment method:
- Add a new grid view, called
Debt totals by payment means - Drag the attribute
PaymentMeansinto the View Attributes list - Drag the attribute Count() into the View Attributes list (this attribute is available on any grid view in PhixFlow, regardless of what attributes have been set up in the stream)
- Drag the attribute
DebtLevelinto the View Attributes list- Now double-click on this attribute in the View Attributes list
- You will see the stream view attribute configuration form:
- Set the Name to
TotalDebtLevel - Select the Stream Function: Sum
- Press
- Set the Name to
- Press
on the main stream view configuration form to save your changes
View the results.
Create a 3D pie chart
Now you will create a further chart on the stream Overall Debt Levels, to give an overview of proportions of debt by various payment means. Create a new view and dashboard with the settings:
Name | Debt overview by payment means |
Display Type | 3D Pie Chart |
| DATA ATTRIBUTE | DebtLevel - make this an aggregate attribute. Once you have added it to the view:
|
LABEL ATTRIBUTE | PaymentMeans |
Show Legend | tick |
Show Values on Charts | tick |