Users of the most recent version of Tableau desktop can connect directly to their LeanKit data through the use of a Tableau Web Data Connector (WDC). This allows users to build and maintain custom reports that reference LeanKit data.
Your LeanKit account must have reporting API enabled in order for any LeanKit WDC to function properly. Please contact your LeanKit account representative or firstname.lastname@example.org for further information.
Available Connectors in LeanKit
Listed below are the currently available WDCs.
Copy the link into Tableau to extract the desired data:
- Cards - https://bit.ly/2Ge6gCt
- Card Positions - https://bit.ly/2pLSdJV
- Comments - https://bit.ly/2I9jjkK
- Blocked History - https://bit.ly/2GcjOyi
- Connections - https://bit.ly/2Gck9ky
- Current User Assignments - https://bit.ly/2uuCvI6
- User Assignment History - https://bit.ly/2I8uPwO
- Current User Task Assignments - https://bit.ly/2IXCbV6
- User Task Assignment History - https://bit.ly/2GfFjdb
- Custom Fields - https://bit.ly/2DZJxnj
- Lanes - https://bit.ly/2pIZiKg
- Tags - https://bit.ly/2pKEoe0
- Tasks - https://bit.ly/2GhsXl0
To get started connecting your LeanKit data to Tableau, open up Tableau Desktop and select Web Data Connector from the data connection panel.
Or, if you’re already in a worksheet, click Connect to Data and select Web Data Connector from there.
Next, paste the appropriate web data connector link from the list above.
Upon navigating to the appropriate WDC URL, you will be asked to specify your both your LeanKit account URL as well as authentication information.
You can authenticate by either entering your username and password.
Or, you can use a previously generated web token. Click here for more information on obtaining a web token.
Once you have authenticated, you can select which board(s) you’d like to extract data from. You can choose to extract data from all of the boards in the account by selecting All Boards at the top of the list, or you can hold down the CTRL or CMD key on your keyboard while clicking to select multiple, specific boards.
Once you’ve selected the board(s) to include, click Submit.
Depending on your version of Tableau Desktop, you will be brought back to the data source view, and can safely navigate to a worksheet.
Once in a worksheet, you should see the appropriate data source listed in the upper left of Tableau Desktop, as well as the available dimensions and measures associated with that data source.
Repeat these steps, selecting a different WDC if you need to combine multiple LeanKit data sources to build your custom report.
You can always refresh the data sources directly through Tableau to get the most current data available from your LeanKit account.
You may be asked to re-authenticate depending on the duration since your last refresh.
LeanKit offers different data caching frequencies depending on your account’s level of access to the reporting API. Please check with you LeanKit account representative before assuming that your reports are pulling up-to-the-minute data.