sap-reporting-custom-charts-illustration
Author: Bogdan Gorka
Published: February 7, 2021
CategoryJira for SAP

Managing large IT projects such as SAP S4/HANA implementation or upgrade, requires controlling a lot of items, their statuses, people responsible, budgets, and deadlines. The critical role plays the methodology (such as Activate) outlining the project delivery process supported by the progress reporting, which helps to control this process. This methodology and reporting can be very well enabled by Jira Software.

Jira Software used as Project Management Information System (PMIS)

The success of Jira comes from its flexibility. I guess you already know that Jira after install does not have too many processes which are ready to use. Actually, I cannot think of a single example when a customer used some Jira configuration without any changes to it. The fact is that if you want to use this software for some more customized purposes, such as managing large IT projects delivery, you need to configure it to suit your needs. 

Reporting app - Custom Charts

A very good thing about Jira is that its core functionality can be extended with so-called Apps (previously called Plugins). There are many Jira Apps for various purposes and a few of them are used to visualize data stored in Jira - reporting. Some reporting functionality is available in Jira ‘out-of-the-box’ but it is very basic (if not rudimentary). That is why for more advanced reporting you need an App which will extend Jira's functionality in this direction. 

My favorite Jira App for reporting is Custom Charts, which is available for Jira Server/DC and Cloud. In this article, I will show you a few tips on how you can use this tool to build a Solution Readiness Dashboard for implementing SAP S/4HANA.

Status reporting in SAP projects

I do not want to go into too much detail here about managing SAP projects. However, for the purpose of this article, you should know that:

  1. such large projects are normally organized into Phases (or Stages). During each of these stages a delivery team, which is organized into Workstreams, delivers various project products - tangible results, which can be tested and handed over to a client 
  2. there is a limited period of time and resources available to deliver a certain amount of project products 
  3. there are hundreds of these products and each of them needs to be kept under control. Jira, with its workflows and flexibility, can be adapted to be used to manage and control the status of every project product delivery.

To visualize the delivery status of project products in an aggregated way, as a Project Manager you need a Reporting Dashboard. In SAP Projects, such dashboards are sometimes called SAP Solution Delivery Dashboard.

Status report elements

The dashboard that I am presenting in this article is just an example to showcase some of the capabilities of the Custom charts and some other Jira functionalities.

General overview gadget

sap-reporting-custom-charts-02

Each status report which is presented to higher management needs to have some sort of executive overview.

This needs to be brief and concise, especially when you create a weekly status report. For this purpose, I used a text gadget, which is disabled by default. You can read in this article how to enable this gadget. However, please note that this solution is not recommended if your Jira server is available from the Internet. This is described in the aforementioned article too.

The tile chart

sap-reporting-custom-charts-03

With this type of chart, you can show a summary of issues, story points or budget spent in a form of tiles with rounded edges.

Just like with any other functionality for visualization, you can easily get carried away and overcomplicate your chart. You need to be critical and follow the rule ‘less is more’. 

sap-reporting-custom-charts-04

My advice - do not put charts like the one above as this will not help the reader to understand your project’s status.

2D line chart

No matter what reporting tool you use, it is always a challenge to select data and chart type to answer a question your management has. If you have a lot of data that you want to compare and squeeze into one chart, a 2D line chart can be a good choice.

sap-reporting-custom-charts-05

In this example, I wanted to show the main project product groups and their statuses comparison across all streams. In this way I know if some streams are not lagging behind compared to the Phase elapsed time.

Classic bar charts

In a reporting application classic bar charts could not be missing. 

sap-reporting-custom-charts-06
sap-reporting-custom-charts-07

There are quite a few interesting functionalities here but I would like to mention my favorite only:

(1) you do not have to worry about the series names. I used the Components functionality in Jira to assign each project product to a specific Workstream. But in reporting, I can rename Jira elements like 'Components' to 'Workstreams'

sap-reporting-custom-charts-08

2) you can combine a few series and display them together - this a great functionality to have

sap-reporting-custom-charts-09

Numbers bar charts

Sometimes you need to simply display a series of numbers in the most simplistic way possible so it is legible for your project stakeholders. Custom charts have two formats for you - 1D Table and 2D Table. 

sap-reporting-custom-charts-10

What is missing in Custom Charts?

I cannot say that there is something urgent needed for me now in the Custom Charts now.

However, to make the Status Reporting informative I also need to display the status of some key products as a simple table with filter results and statuses. The generic colors offered by Jira do not fit into how I want my report to look like. If something, for example, a Milestone, is at risk, I want to be able to show it in Red. For this purpose, I am using some less know functionality in another plugin for Jira.

sap-reporting-custom-charts-11

Before you go...

There are other alternatives on Atlassian Marketplace which will show up if you type Reporting.

In my opinion, a massive advantage of Custom Charts is its intuitive interface. It truly is an 'easy' reporting app for everyone. To use this app you do not need to even read their user manual because you will learn the basics yourself just by experimenting (of course you need to know the JQL basics).

Later, when you want to find out more advanced features and best ways of using them, I would suggest reviewing the documentation.


Spread the knowledge, share with others

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
Teach Yourself Jira Ebook Cover

Get free e-book

Teach Yourself Jira Administration

Join our ever growing group of Jira Administration enthusiasts and get this e-book for free.

Teach Yourself Jira Administration is my selection of best Jira Administration courses for Jira - over 30 hours of recordings.

In this e-book I selected only the few recommended courses with good and effective content for which you do not have to pay (if you follow my instructions).