Multi-JQL Pie Chart Macro for Confluence Cloud

XMLWordPrintable

      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")

              Assignee:
              Unassigned
              Reporter:
              Vinod Reddy - [Atlassian Support]
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: