Jira Lean Analytics Dashboard v1.1
I have released v1.1 of the Jira LAD along with the updated documentation. Here are the enhancements that are included in this version:
Removal of Google Sheets API — The Google Sheets API is no longer used within the LAD. There is no change to functionality or capability and it makes the initialization of the LAD much easier than previous versions. The initialization can now be done directly from the LAD menu needing only a few clicks all on the same screen
Operational and Non-Operational Work Metrics — Weekly summarizations of Operational and Non-Operational work. These metrics can be very helpful in understanding where your team is spending its time and capacity planning for new development. They also have potential application in determining Capex and Opex
There are six new charts related to the op/non-op metrics:
- cht_WeeklyOperationalVsNonOperationalGrowth
- cht_WeeklyOperationalVsNonOperationalGrowthPercentage
- cht_WeeklyOperationalVsNonOperationalIssuesCompleted
- cht_WeeklyOperationalVsNonOperationalIssuesCompletedPercentage
- cht_WeeklyOperationalVsNonOperationalWorkingTime
- cht_WeeklyOperationalVsNonOperationalWorkingTimePercentage
A new configuration section has been added to the Query Configurations tab named Operational Work Configurations
You define what issues are categorized as operational using components, issue types, or a combination of the two. Any issue containing any of the components listed in the configuration or are of the issue type of any of the issue types listed in the configuration will be categorized as operational. Any issue not meeting the above criteria will be categorized as non-operational
Workflow Configuration Validation — The LAD will now run 3 validations on the workflow configurations prior to refreshing the data. The validations will help prevent improper set up of the workflow configurations that can lead to incorrect metric calculations. The validations are as follows:
- All statuses contained in the individual workflows are also contained in the combined workflow
- For each workflow, the statuses listed in the Cycle Time and Lead Time columns are in the same order as the statuses listed in Statuses column
- For each individual workflow, the ending statuses of the Cycle Time and Lead Time columns are one of the final statuses in the combined workflow Cycle Time and Lead Time columns
Processed Dates Format Configuration — There is a new configuration named Processed Dates Format that allows you to set the configuration for most of the dates in the Processed Data tab. Some of the dates in the Processed Data tab use the configuration specified in the Query Fields Configuration section which is why I say most dates
Report Initialization Performance Improvement — In previous versions running the report initialization would take a few minutes. The initialization now only takes a couple of seconds to run. In addition refreshing data and building dashboards is slightly faster than in previous versions
Documentation Improvements — I had some feedback that it was difficult to determine from the documentation how to get started in setting up the LAD. I restructured the document so it is a more logical flow. It starts off with navigation, initialization, and configuration. In addition I added a section to explain how the automatic execution of the LAD is configured. Finally, I corrected some typos and added some missing elements such as the Jira Server Type configuration and a number of data columns that were not documented