Does the PowerBI Connector add-on allow you to track sub-statuses?

[Kianna Lavigne]

Does the PowerBI Connector add-on allow you to track sub-statuses? 

From what I can see, Jira natively only tracks time within the broader status categories :"To Do," "In Progress," and "Done", but not the sub-statuses. So for example, I can't currently see how long a ticket has been sitting in "Waiting for Customer" or "Waiting for Support," which would be really valuable to track.

Does the connector allow for this type of tracking? Currently, exports to csv and uploading them into PowerBI does not allow for that level of tracking.

[Gor Greyan · Accepted solution]

Hi @Kianna Lavigne

Welcome to the Atlassian Community!

If by sub-statuses you mean actual Jira workflow statuses such as Waiting for Customer and Waiting for Support, then yes,  this is possible with Power BI Connector for Jira by Tempo. We are using this one, for example.

The connector provides Time in Status data, so you can report on how long a work item spent in each workflow status, rather than only looking at the broader To Do / In Progress / Done status categories.

Documentation here.
https://help.tempo.io/powerbiconnector/latest/

If you're referring to a different Power BI Connector Marketplace app, could you share its name/link? The available historical and time-in-status data depends on the specific connector.

[Kianna Lavigne]

Hi Gor, thanks for answering. Yes I am looking to track how long a ticket has been waiting for customer for example. Currently, Jira export does not track that. It only tracks time changes on the broader Status categories. 

I was looking at this connector: Power BI Connector for Jira | Atlassian Marketplace