Blog

All CelesteCS blog articles, grouped by product. Newest articles are listed first in each group.

• CelesteCS Math for Confluence (20)
  • IFERROR and IFNA: a clean value instead of an error in Confluence formulas
  • Calculated columns and totals by category in a Confluence table, without Databases or an Excel attachment
  • Replacing the retired Version Report and Epic Burndown with a live Confluence page
  • Summing story points by sprint and component in Confluence
  • Rolling up time from Sub-tasks to the Epic on a Confluence page
  • A weekly trend chart of Jira issue counts on a Confluence page
  • Building a live Jira progress dashboard with CelesteCS Math
  • Charting your Confluence tables with the new Chart macro
  • Avoiding StackOverflowError from self-referencing Chart and Numerical Expression macros
  • SUMIF, COUNTIF and AVERAGEIF: conditional aggregates without extra columns
  • Calculating one column from another: per-row formulas like price times tax
  • Adding a running total to any Confluence table
  • Performing calculations over Jira issue fields
  • Determining the field ID by its name
  • Collecting logs for CelesteCS Math
  • CelesteCS Math Plugin: Charts
  • CelesteCS Math Cloud Plugin: Plugin permissions and "Read own page" error
  • CelesteCS Math Plugin: Working with Datetime values
  • CelesteCS Math Plugin: Working with Tables
  • CelesteCS Math Cloud Plugin: Quick Start Guide
• CelesteCS Conditions for Confluence (9)
  • Coloring table cells by how many days are left until a date
  • Formatting several tables on one page with a single Conditional Rules Manager
  • Comparing two columns instead of a fixed value with formula-based rules
  • Highlighting blank or missing values before they become a problem
  • Turning table values into colored status lozenges automatically
  • Excel-style conditional formatting in Confluence: 3-Color Scales, Data Bars and Icon Sets
  • Highlighting top performers, overdue dates and duplicates with the new Conditional Rule conditions
  • Red, amber, green: highlighting Jira Epic status automatically in Confluence tables
  • Text highlight and replacement with CelesteCS Conditions
• CelesteCS Reporting for Confluence (19)
  • Let readers filter and sort a Jira report on a Confluence page
  • How many times was an issue carried over? Sprint carry-over per issue and per sprint
  • A sprint-end report with Original Estimate totals, without Automation
  • Flow metrics from Jira on a Confluence page: WIP, throughput and lead time
  • Replacing the retired Time Tracking report with a Confluence table
  • Page Properties Report with totals, formulas and sorting
  • Only open projects, sorted by due date: filtering Page Properties
  • A one-line status list of all projects from Page Properties
  • Story estimates including Sub-tasks in team-managed Jira projects
  • A content inventory of a Confluence space: every page with its creator, last editor and age
  • Listing each Epic's linked issues on a Confluence page
  • Original estimate vs. logged time: a live Confluence report from Jira
  • Formatting numbers, currency and dates automatically in your report columns
  • Turning a JSON export into a Confluence table with Reporting Json Data Provider
  • Building a multi-level Jira issue tree with Reporting List View
  • Reading Jira custom fields that the Jira Issues macro won't show you
  • Sorting, deduplicating and limiting your reports without extra macros
  • Reporting on what Confluence Analytics can't show you: page creators and last editors
  • Beyond the Jira Issues macro: fully custom Confluence reports from Jira data
• CelesteCS JQL Extensions for Jira (3)
  • Working with clones, duplicates and blockers using CelesteCS JQL Extensions
  • Flattening an Epic-and-Stories tree into one report with jqlxFlattenedTwoLevelTree
  • Finding issues that fell through the cracks with CelesteCS JQL Extensions
• CelesteCS Rotator for Confluence (1)
  • Bulk-fixing sideways phone photos in Confluence without losing quality
• Several products (2)
  • Calculated columns, totals and highlighting for business data in Confluence
  • CelesteCS Cloud plugins: Jira integration reliability improvements