In order to build a widget you need to select the correct data structure on the Fields tab. This means that selected fields should have the correct data type and order and for some widget types they should also have certain names.
Data type of a field comes from SQL Server and you can distinguish between field data types by the predefined value in the Format column on the Fields grid.
Below is a list of possible data types:
|
Format Value |
Data Type |
| <empty> |
Number |
| Decimal |
Decimal |
| Integer |
Number |
| Date | Date |
In order to set up columns order use the Cols order list-box next to the Fields grid where you can re-order selected fields using the Up and Down buttons.
Below you can find the correct data structures for each widget type.
Please note: “1..n”,”2..n”, etc. in the Order column means that the widget can display more than one series of data.
Area Chart
|
Order |
Type |
| 1 |
Date |
| 2..n |
Number |
Example: Assignment Costs by Day
Bar Chart
|
Order |
Type |
| 1 | Any |
| 2..n | Number |
Example: Projects by Department
Bubble Chart
|
Order |
Type |
| 1 |
Number |
| 2 |
Number |
| 3 |
Number |
Example: Projects by % Complete and % Work Complete
Column Chart
|
Order |
Type |
| 1 | Any |
| 2..n |
Number |
Example: Tasks by Critical Status
Gauge Chart
|
Order |
Type |
| 1 | Number |
Example: Portfolio Average % Complete
Heatmap Table
|
Order |
Type |
| 1 |
Any |
| 2..n | Number |
Example: Resource Capacity by Day
Indicator
| Order | Type |
| 1 | Any |
Example: Portfolio Average Cost
Line Chart
|
Order |
Type |
| 1 | Date |
| 2..n | Number |
Example: Assignment Work By Day
Pie Chart
|
Order |
Type |
| 1 |
Any |
| 2..n |
Number |
Example: Tasks by Critical Status
Scalar
|
Order |
Type |
| 1 |
Any |
Example: Portfolio Average Cost
Scatter Chart
|
Order |
Type |
| 1 |
Any |
| 2 | Number |
| 3 | Number |
Example: Projects by Work and Actual Work
Stacked Column
|
Order |
Type |
| 1 | Any |
| 2..n | Number |
Example: Portfolio Actual and Remaining Work by Department
Stock Chart
| Order |
Type |
| 1 |
Date |
| 2..n | Number |
Example: Assignment Work By Day
Table
| Order | Type |
| 1..n | Any |
Example: Portfolio Summary
Timeline
Timeline requires columns named in a certain way.
| Order | Type |
Note |
| 1 | Any | Display Name should be “Title” |
| 2 | Date | Display Name should be “StartDate” |
| 3 | Date | Display Name should be “EndDate” |
Example: Project Tasks
Treemap
|
Order |
Type |
| 1 | Any |
| 1 | Number |
Example: Project Costs
