Skip to main content

37 posts tagged with "jira"

View All Tags

How to Export Jira Issues to Excel for Stakeholder Reporting

· 6 min read
Quick Answer

Export Jira issues to Excel or CSV for stakeholder reporting, custom analysis, and cross-project visibility. Use JQL queries to filter exactly the data you need.

What you'll learn
  1. How to use Jira's built-in export to CSV and Excel
  2. How to customize which fields are included in exports
  3. How to write JQL queries for targeted, filtered exports
  4. How to schedule automated exports for regular reporting
  5. How to build Excel reports from Jira export data

Jira's built-in reports are useful, but stakeholders often want data in Excel. Whether it is a weekly status report, a velocity trend analysis, or a custom dashboard, Excel gives you full control over how Jira data is presented.

This guide covers how to export Jira issues to Excel and CSV, from simple one-click exports to scheduled automated reports.

Jira Backlog Grooming: The Complete Guide to Refining Stories

· 7 min read
Quick Answer

Backlog grooming is the process of refining, estimating, and prioritizing Jira stories so they are sprint-ready. A well-groomed backlog makes sprint planning fast and predictable.

What you'll learn
  1. How to set up a grooming cadence that keeps your backlog healthy
  2. A template for writing acceptance criteria that eliminate ambiguity
  3. The planning poker workflow for accurate story point estimation
  4. How to rank stories so the highest-value work always comes first

A messy backlog is the silent killer of Agile teams. Stories pile up without refinement, acceptance criteria are vague, and sprint planning becomes a guessing game. By the time the team realizes the backlog is broken, velocity has dropped and trust in the process has eroded.

Backlog grooming — also called refinement — is the antidote. It is the ongoing process of reviewing, splitting, estimating, and prioritizing stories so the backlog is always sprint-ready.

This guide covers a complete grooming workflow in Jira, from writing acceptance criteria to ranking by business value.

How to Set Up Jira Dashboards for Sprint Tracking and Stakeholder Visibility

· 5 min read
Quick Answer

Jira dashboards provide real-time visibility into sprint health, velocity trends, and team performance. Configure gadgets, create JQL filters, and share dashboards with stakeholders.

What you'll learn
  1. How to create and configure a Jira dashboard from scratch
  2. Which gadgets track sprint health vs long-term trends
  3. How to set up JQL filters for custom dashboard views
  4. How to share dashboards and set up email subscriptions

A well-designed Jira dashboard gives your team instant visibility into sprint health, backlog status, and delivery trends. But most dashboards are either empty defaults or cluttered messes that nobody uses.

This guide covers how to build dashboards that actually provide value — from sprint tracking to stakeholder reporting.

Jira JQL Cheat Sheet: 20 Queries Every Team Needs

· 5 min read
Quick Answer

JQL (Jira Query Language) lets you search for issues using fields, operators, and values. Master 20 essential queries to find issues fast, track sprint health, and build custom dashboards.

What you'll learn
  1. The JQL syntax basics that power every query
  2. 20 copy-paste queries for common searches
  3. How to use JQL functions for dynamic, date-aware filters
  4. How to save and share filters for dashboards

Jira's search is powerful, but most teams only scratch the surface. They type a few keywords into the search bar, get overwhelmed by results, and give up. JQL — Jira Query Language — is the key to unlocking precise, repeatable searches that find exactly what you need.

This cheat sheet covers 20 essential JQL queries, from basic field searches to advanced functions. Each query is copy-paste ready.

Jira Permissions Explained: How to Set Up Project Security Without Breaking Workflows

· 6 min read
Quick Answer

Jira permissions control who can view, create, and modify issues. Use permission schemes, project roles, and issue-level security to balance access with data protection.

What you'll learn
  1. The difference between global, project, and issue-level permissions
  2. How to create and configure permission schemes in Jira
  3. How to set up project roles for flexible, role-based access control
  4. How to restrict issue visibility with issue-level security
  5. How to test and audit permissions to verify correct configuration

Permissions in Jira control who can do what. Without proper configuration, either everyone can see everything (security risk) or the permissions are so locked down that work stops (productivity risk).

The key is finding the balance: enough access for people to do their jobs, not so much that sensitive data is exposed. This guide covers how to configure Jira permissions without breaking workflows.

How to Run Jira Sprint Retrospectives That Drive Real Change

· 6 min read
Quick Answer

Sprint retrospectives drive improvement when they produce specific, assigned action items tracked in Jira. Use structured formats, gather anonymous input, and follow up on actions every sprint.

What you'll learn
  1. How to choose the right retro format for your team's maturity and energy
  2. Facilitation techniques that ensure every voice is heard
  3. How to turn retro feedback into trackable Jira action items
  4. Why most retros fail and how to build accountability into the process

Sprint retrospectives are supposed to be the engine of continuous improvement. But for many teams, they devolve into the same complaints, the same vague commitments, and the same problems month after month. The retro becomes a ritual without results.

The issue is not the concept — it is the execution. Without structure, facilitation, and follow-through, retros produce feelings but not changes. This guide fixes that.

Jira Workflow Automation: How to Automate Repetitive Tasks and Save Hours

· 6 min read
Quick Answer

Jira automation rules eliminate repetitive tasks like assignment, notifications, and status transitions. Use triggers, conditions, and actions to build rules without code.

What you'll learn
  1. How to identify which Jira tasks are good automation candidates
  2. How to build automation rules using triggers, conditions, and actions
  3. How to test, debug, and refine automation rules
  4. How to scale automation across projects and teams

Every Jira team has repetitive tasks: assigning bugs to the QA lead, transitioning issues when a pull request is merged, sending notifications when a sprint starts. These tasks follow consistent rules, which makes them perfect for automation.

Jira's built-in automation engine lets you create rules without code. This guide covers how to identify automation candidates, build rules, and scale them across your organization.

How to Plan Jira Sprints That Actually Work (Step-by-Step Guide)

· 7 min read
Quick Answer

Sprint planning in Jira requires grooming your backlog, calculating team capacity, and running a structured planning meeting. This guide covers the complete workflow from backlog refinement to daily sprint tracking.

What you'll learn
  1. How to groom and rank your Jira backlog so planning meetings are fast
  2. A formula for calculating sprint capacity that accounts for real-world interruptions
  3. The step-by-step sprint planning meeting format that keeps teams aligned
  4. How to use burndown charts and board filters to track progress daily

Sprint planning is where most Agile teams either build momentum or lose it. A poorly run planning meeting produces a sprint full of half-finished stories, scope creep, and a team that stops trusting the process.

The problem is not Jira itself — it is how teams use Jira during planning. Without a structured workflow, the backlog becomes a dumping ground, story points become guesswork, and the sprint goal vanishes by Wednesday.

This guide walks through a complete sprint planning workflow in Jira, from backlog grooming to daily tracking, so your team ships predictably every two weeks.

How to Create Jira Issues from Templates (3 Methods, With Examples)

· 7 min read
Who should read this
  • Jira admins and project leads standardizing ticket creation across teams
  • Engineering teams who retyped the same bug/incident/story structure every week
  • Anyone asked "is there a template for this?" and wanting a real answer
What you'll learn
  1. Why Jira's native project templates don't solve per-ticket templating
  2. Three ways to create issues from templates (starter library, custom, GitHub import)
  3. How variables like \{\{currentUser\}\} and \{\{today+7d\}\} make templates dynamic
  4. Auto-applying templates so the right one loads for each issue type

The scenario every Jira team hits: a new bug comes in, and the reporter writes "it's broken" with no steps to reproduce, no environment, no severity. Or an incident gets logged without the services-affected checklist. You write a Confluence page titled "How to file a good bug," link to it from the project home, and nobody reads it. The tickets keep coming in malformed.

The real fix is to put the template on the ticket — so the moment someone opens Create Issue for a bug, the description already has the "Steps to reproduce / Expected / Actual / Environment" structure, the right labels, and the right assignee. That's per-issue templating, and Modern Issue Templates for Jira does exactly that. This guide covers three ways to create issues from templates, from quickest to most customized.

Mermaid Diagrams for Jira Sprint Workflows — Which Diagrams Actually Help the Standup

· 8 min read
Who should read this
  • Scrum masters and eng leads who run standups from Jira
  • Development teams deciding which diagrams to maintain across a sprint
  • Anyone who wants to know which of Mermaid's 29 diagram types are actually useful for agile work
What you'll learn
  1. The four Mermaid diagram types a sprint team actually reaches for
  2. How to embed each one inside a Jira issue, with copy-paste syntax
  3. When a diagram belongs in Jira vs. Confluence
  4. The full 29-type reference for less common needs

Every team that adopts Jira diagrams hits the same moment: you discover Mermaid supports 29 diagram types, you get excited, and then you realize you have no idea which ones to actually use during a sprint. Most of them never get drawn. The diagrams that earn their keep are the ones that make a standup faster, an onboarding doc clearer, or a ticket unambiguous — and those are a small, repeatable subset.

This post is the workflow guide we wish we'd had: the four diagram types a sprint team actually uses, each with a real scenario and copy-paste syntax you can drop straight into a Jira issue. The full 29-type reference follows, so the same page works as both a sprint playbook and a complete catalog.