User Tools

Site Tools


Sidebar

widget_editor:data_structures_by_widget_type:start

Data Structures by Widget Type

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> String
Decimal Number
Integer Number
Date Date

In order to set up columns order use the Cols order listbox 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. :!: 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
2 Number

Example

Project Costs

widget_editor/data_structures_by_widget_type/start.txt · Last modified: 2015/05/19 07:59 by Alyona Gonchar