Help & Support
Follow

Advanced Reporting Site: LeanKit Data Source Reference Guide

Your LeanKit custom reporting site, hosted on Tableau Server, comes with many pre-connected data sources to make report generation simpler. Understanding these data sources will help you create new Tableau workbooks with ease.

 

Data Sources

 

Data Source Name

# of Workbooks Connected to Data Source

Workbook

Cards v0.2

7

Average Time to Complete by Card Type

Blocked Cards by Board

Creation Trends

Problem Report

Started - Completed Dashboard

Total Cards by Board

User WIP

Boards v0.2

1

Creation Trends

Lanes v0.2

1

Creation Trends

Task Cards v0.2

1

Creation Trends

Users v0.2

1

Creation Trends

User Assignments v0.2

1

User WIP

Card Blocked Periods v0.2

0

-

Card Lane Containment Periods v0.2

0

-

Taskboard Lanes v0.2

0

-

 

 

Data Source Details

This walks through what data is available within each data source, information about each piece of data, and sample data.

 

Boards

The Boards data source table below shows the available fields in the data source as well as a sample value, the data type, the max length and the ability to allow null values for each field.

 

Field Name

Sample Value

Data Type

Max Length

Allow Nulls

Board Creator

fname.lname@company.com

Text

510

True

Board Creator ID

308525710

Number

8

True

Board ID

308993946

Number

8

False

Board Title

IT OPS Team

Text

510

True

Creation Date

9/1/15 8:57:27 PM

Date/Time

8

True

Description

This board outlines IT Ops processes

Text

2000

False

 

Card Blocked Periods

The Card Blocked Periods data source table below shows the available fields in the data source as well as a sample value, the data type, the max length and the ability to allow null values for each field.

 

Field Name

Sample Value

Data Type

Max Length

Allow Nulls

Blocked By User Email Address

fname.lname@company.com

Text

510

True

Blocked By User Full Name

Fname Lname

Text

510

True

Blocked By User ID

308525710

Number

8

True

Blocked From Date

9/10/15 3:56:12

Date/Time

8

True

Blocked Reason

Waiting on process owner answer

Text

2000

True

Blocked To Date

9/17/15 6:49:29 PM

Date/Time

8

True

Board ID

307392692

Number

8

True

Board Title

IT OPS Team

Text

510

True

Card ID

308970421

Number

8

True

Card Priority

Normal

Text

10

True

Card Title

Upgrade Assessment

Text

510

True

Card Type ID

307390374

Number

8

True

Card Type Title

Software Upgrade

Text

510

True

Custom Icon ID

Null

Number

8

True

Custom Icon Title

Null

Text

510

True

Unblocked By User Email Address

fname.lname@company.com

Text

510

True

Unblocked By User Full Name

Lname, Fname

Text

510

True

Unblocked By User ID

307392692

Number

8

True

Unblocked Reason

Received results.

Text

2000

True

Card Size

2

Number

4

True

Duration Seconds

615,197

Number

8

True

Total Blocked Duration (Days)

7

Number

4

True

Total Blocked Duration (Hours)

171

Number

8

True

Total Blocked Duration Minus Weekends (Days)

5

Number

4

True

 

Card Lane Containment Periods

The Card Lane Containment Periods data source table below shows the available fields in the data source as well as a sample value, the data type, the max length and the ability to allow null values for each field.

 

Field Name

Sample Value

Data Type

Max Length

Allow Nulls

Board ID

309722459

Number

8

False

Board Title

IT Tableau Team

Text

510

True

Card ID

309731807

Number

8

False

Card Priority

Normal

Text

8

True

Card Title

Tableau Conference

Text

510

True

Card Type ID

309713576

Number

8

False

Card Type Title

Conferences

Text

510

False

Containment End Date

Null

Date/Time

8

True

Containment Start Date

10/29/15 5:00:26 PM

Date/Time

8

False

Custom Icon ID

Null

Number

8

True

Custom Icon Title

Null

Text

510

True

Full Lane Title

November -> Conferences

Text

1028

True

Lane Class

Backlog

Text

7

True

Lane ID

309730442

Number

8

False

Lane Title

Conferences

Text

510

True

Lane Type

Not Set

Text

10

True

Moved Into By User Email Address

fname.lname@company.com

Text

510

True

Moved Into By User Full Name

Lname, Fname

Text

1024

True

Moved Into By User ID

308525710

Number

8

True

Moved Out By User Email Address

fname.lname@company.com

Text

510

True

Moved Out By User Full Name

Lname, Fname

Text

1024

True

Moved Out By User ID

308525710

Number

8

True

Card Size

10

Number

4

True

Total Containment Duration (Days)

83

Number

4

True

Total Containment Duration (Hours)

1,975

Number

4

True

Total Containment Duration Minus Weekends (Days)

59

Number

4

True

 

Card

The Cards data source table below shows the available fields in the data source as well as a sample value, the data type, the max length and the ability to allow null values for each field.

 

Field Name

Sample Value

Data Type

Max Length

Allow Nulls

Actual Duration (Days)

Null

Number

4

True

Actual Duration (Hours)

Null

Number

4

True

Actual Duration Minus Weekends (Days)

Null

Number

4

True

Archived Date

Null

Date/Time

8

True

Attachments Count

0

Number

4

True

Card ID

309731807

Number

8

False

Card Link Name

 

Text

510

False

Card Link Url

 

Text

4000

False

Card Size

10

Number

4

True

Card Title

Tableau Conference, Austin TX

Text

510

True

Card Type ID

309713576

Number

8

False

Card Type Title

Software Conference

Text

128

False

Comments Count

2

Number

4

True

Connection Board ID

Null

Number

8

True

Creation Date

10/29/15 5:00:26 PM

Date/Time

8

True

Current Blocked Reason

 

Text

510

False

Current Board ID

309722459

Number

8

False

Current Board Title

IT Tableau Team

Text

510

True

Current Full Lane Title

November -> Conferences

Text

1028

True

Current Lane Class

Backlog

Text

7

True

Current Lane ID

309730442

Number

8

True

Current Lane Position

0

Number

4

True

Current Lane Title

Conferences

Text

510

True

Current Lane Type

Not Set

Text

10

True

Custom Icon ID

Null

Number

8

True

Custom Icon Title

Null

Text

510

True

         

External Card ID

Tableau 2016

Text

100

False

Is Card Blocked

False

Boolean

1

True

Last Activity Date

12/15/15 12:52:14 AM

Date/Time

8

True

Last Actual Finish Date

Null

Date/Time

8

True

Last Actual Start Date

11/07/15 5:00:26 PM

Date/Time

8

True

Last Attachment Date

Null

Date/Time

8

True

Last Comment Date

12/15/15 12:52:14 AM

Date/Time

8

True

Last Moved Date

10/29/15 5:00:26 PM

Date/Time

8

True

Parent Card ID

Null

Number

8

True

Planned Duration (Days)

Null

Number

4

True

Planned Duration (Hours)

Null

Number

4

True

Planned Duration Minus Weekends (Days)

Null

Number

4

True

Planned Finish Date

Null

Date/Time

8

True

Planned Start Date

Null

Date/Time

8

True

Priority

Normal

Text

8

True

Tags

 

Text

4000

False

 

Please note that field values can be empty rather than Null as seen in the sample above.

Lanes

The Lanes data source table below shows the available fields in the data source as well as a sample value, the data type, the max length and the ability to allow null values for each field.

 

Field Name

Sample Value

Data Type

Max Length

Allow Nulls

Activity ID

Null

Number

8

True

Board ID

307392692

Number

8

True

Board Title

IT OPS Team

Text

510

True

Can Hold Cards

True

Boolean

1

True

Child Lane Count

1

Number

4

True

Creation Date

9/3/15 8:52:16 PM

Date/Time

8

True

Full Lane Title

Implement -> Implementing

Text

1020

True

Has Child Lanes

False

Boolean

1

True

Is Completed Lane

False

Boolean

1

True

Is Default Drop Lane

False

Boolean

1

True

Is Top Level Lane

False

Boolean

1

True

Lane Class

Backlog

Text

7

True

Lane ID

309014355

Number

8

False

Lane Orientation

Vertical

Text

10

False

Lane Policy

Null

Text

max

True

Lane Position

2

Number

4

True

Lane Title

Implementing

Text

510

True

Lane Type

In Process

Text

10

True

Lane Width

1

smallNumber

2

True

Parent Lane ID

309014354

Number

8

True

Parent Lane Title

Implement

Text

510

True

WIP Limit

0

Number

4

True

 

Task Cards

The Task Cards data source table below shows the available fields in the data source as well as a sample value, the data type, the max length and the ability to allow null values for each field.

 

Field Name

Sample Value

Data Type

Max Length

Allow Nulls

Actual Duration (Days)

Null

Number

4

True

Actual Duration (Hours)

Null

Number

4

True

Actual Duration Minus Weekends (Days)

Null

Number

4

True

Archived Date

10/28/15 12:00: AM

Date/Time

8

True

Attachments Count

0

Number

4

True

Card ID

309350261

Number

8

False

Card Link Name

 

Text

510

False

Card Link Url

 

Text

4000

False

Card Size

0

Number

4

True

Card Title

Get feedback on training delivered.

Text

510

True

Card Type ID

309361491

Number

8

False

Card Type Title

subtask

Text

128

False

Comments Count

0

Number

4

True

Creation Date

9/28/15 5:24:46 PM

Date/Time

8

True

Current Blocked Reason

 

Text

510

False

Current Board ID

309371181

Number

8

False

Current Board Title

IT OPS Team

Text

510

True

Current Lane ID

309371289

Number

8

True

Current Lane Position

2

Number

4

True

Current Lane Title

ToDo

Text

510

True

Current Lane Type

Ready

Text

10

True

Custom Icon ID

Null

Number

8

True

Custom Icon Title

Null

Text

510

True

Description

 

Text

max

False

External Card ID

 

Text

100

False

Is Card Blocked

False

Boolean

1

True

Last Activity Date

10/7/15 8:31:06 PM

Date/Time

8

True

Last Actual Finish Date

Null

Date/Time

8

True

Last Actual Start Date

Null

Date/Time

8

True

Last Attachment Date

Null

Date/Time

8

True

Last Comment Date

Null

Date/Time

8

True

Last Moved Date

10/7/15 8:31:06 PM

Date/Time

8

True

Planned Duration (Days)

Null

Number

4

True

Planned Duration (Hours)

Null

Number

4

True

Planned Duration Minus Weekends (Days)

Null

Number

4

True

Planned Finish Date

Null

Date/Time

8

True

Planned Start Date

Null

Date/Time

8

True

Priority

Normal

Text

8

True

Tags

 

Text

4000

False

 

Taskboard Lanes

The Taskboard Lanes data source table below shows the available fields in the data source as well as a sample value, the data type, the max length and the ability to allow null values for each field.

 

Field Name

Sample Value

Data Type

Max Length

Allow Nulls

Board ID

307392692

Number

8

True

Board Title

IT OPS Team

Text

510

True

Creation Date

2/20/15 10:31:08 PM

Date/Time

8

True

Lane ID

307418864

Number

8

False

Lane Position

0

Number

4

True

Lane Title

ToDo

Text

510

True

Lane Type

Ready

Text

10

True

 

User Assignments

The User Assignments data source table below shows the available fields in the data source as well as a sample value, the data type, the max length and the ability to allow null values for each field.

 

Field Name

Sample Value

Data Type

Max Length

Allow Nulls

Assigned By User Email Address

fname.lname@company.com

Text

510

True

Assigned By User Full Name

Lname, Fname

Text

1024

True

Assigned By User ID

308525710

Number

8

True

Assigned From Date

8/20/15 4:15:25 PM

Date/Time

8

False

Assigned To Date

Null

Date/Time

8

True

Assigned User Email Address

fname.lname@company.com

Text

510

True

Assigned User Full Name

Lname, Fname

Text

1024

True

Assigned User ID

308525710

Number

8

False

Board ID

303378346

Number

8

False

Board Title

MKTG - Community Events

Text

510

True

Card ID

306804469

Number

8

False

Card Size

700

Number

4

True

Card Title

DevOps Enterprise 2015 - Oct 19-21. Agile, CD & DevOps Transformation Summit - San Francisco

Text

510

True

Card Type ID

303377753

Number

8

False

Card Type Title

Event Completed

Text

128

False

Custom Icon ID

Null

Number

8

True

Custom Icon Title

  • Not Set

Text

510

False

Priority

Normal

Text

8

True

Total Duration (Days)

153

Number

4

True

Total Duration (Hours)

3,677

Number

4

True

Total Duration Minus Weekends (Days)

109

Number

4

True

Unassigned By User Email Address

Null

Text

510

True

Unassigned By User Full Name

Null

Text

1024

True

Unassigned By User ID

Null

Number

8

True

 

Users

The Users data source table below shows the available fields in the data source as well as a sample value, the data type, the max length and the ability to allow null values for each field.  

 

Field Name

Sample Value

Data Type

Max Length

Allow Nulls

Creation Date

7/15/15 7:24:14 PM

Date/Time

8

True

Date Format

MM/dd/yyyy

Text

510

True

Email Address

fname.lname@company.com

Text

510

True

First Name

Fname

Text

510

True

Is Account Administrator

False

Boolean

1

True

Is Board Creator

True

Boolean

1

True

Is Enabled

True

Boolean

1

True

Last Access Date

1/13/16 3:25:06 PM  

Date/Time

8

True

Last Name

Lname

Text

510

True

Time Zone

Pacific Standard Time

Text

510

True

User ID

308525710

Number

8

False

 

 

 

 

Doc ID: 1191981384

Have more questions? Submit a request