-
Type:
Suggestion
-
Resolution: Unresolved
-
Component/s: Macros - Jira (Legacy) and Jira Charts
-
None
Issue Summary
As a Confluence user managing complex reporting across multiple projects, I want a Pie Chart macro that can accept multiple, independent JQL queries (one per slice) so that I can create highly customized visual reports that are not limited to a single field's values.
Problem Statement:
The current Jira Chart macro for Confluence only allows a single JQL query as a data source, with slices determined by a single field (e.g., Status or Assignee). This is insufficient for "Cross-Team Demand" reporting where a single pie chart needs to compare unrelated data sets—such as "Bugs from Project A" vs. "Feature Requests from Project B" vs. "Technical Debt from Project C"—in one visual.
Proposed Functionality:
- Multi-Query Input: Allow users to add multiple rows in the macro configuration, where each row consists of a Label and a JQL Query.
- Dynamic Slicing: Each JQL query result count should represent one slice of the pie.
- Customizable Labels: The ability to name each slice manually rather than relying on Jira field names.
- Real-time Totals: The macro should calculate the sum of all query results to determine the percentage distribution for the chart.
Use Case Example:
A "Health Dashboard" pie chart where:
- Slice 1 (Red): project = "PROJ" AND priority = High AND status != Closed (Label: "Critical Blockers")
- Slice 2 (Yellow): project = "PROJ" AND type = Bug AND created > -7d (Label: "New Bugs this Week")
- Slice 3 (Green): project = "PROJ" AND resolution = Fixed AND resolved > -7d (Label: "Resolved this Week")