FluentPro Help Center

What do you need help with?

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>
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



Was this article helpful?

Table of contents

    Back To Top