CelesteCS
  • Home
  • Products
    • Conditions for Confluence
      • End User License Agreement
    • JQL Extensions for JIRA
      • End User License Agreement
    • Math for Confluence
      • End User License Agreement
    • Reporting for Confluence
      • End User License Agreement
    • Rotator for Confluence
  • Support
    • Frequently Asked Questions
    • Documentation
      • Conditions for Confluence
        • Overview
        • How it works
        • How to start
        • Advanced usage examples
        • Conditional Rule macro
        • Conditional 2-Color Scale macro
        • Conditional 3-Color Scale macro
        • Conditional Data Bar macro
        • Conditional Icon Set macro
        • Conditional Rules Manager macro
        • Security and Privacy Statement
        • End User License Agreement
        • Migrating from Data Center to Cloud
      • JQL Extensions for JIRA
        • Overview
        • Functions
        • How to start
        • Security and Privacy Statement
      • Reporting for Confluence
        • Overview
        • Several simple steps to create a report
        • How it works
        • Example: Creating report on Confluence pages
        • Example: Creating report on Jira issues
        • Example: Creating Jira issue tree
        • Example: Listing Jira issues by assignee
        • Tips and tricks
        • Operations
        • Functions
        • Reporting Confluence Data Provider macro
        • Reporting Jira Data Provider macro
        • Reporting Json Data Provider macro
        • Reporting List Item macro
        • Reporting List View macro
        • Reporting Table Item macro
        • Reporting Table View macro
        • Security and Privacy Statement
        • End User License Agreement
        • Migrating from Data Center to Cloud
      • Math for Confluence
        • Overview
        • How to start
        • Numerical Expression macro
        • Chart macro
        • Parameters
        • Operations
        • Functions
          • Math and trigonometry functions
            • SUM function
        • Adding Table Values as Operands
        • Adding Other Macros as Operands
        • Security and Privacy Statement
        • End User License Agreement
        • Migrating from Data Center to Cloud
      • Rotator for Confluence
        • Overview
        • Installation
        • Usage
        • Lossless Rotation
        • Orientation
        • Copying Image Metadata
        • Performing Operations
        • Security and Privacy Statement
        • End User License Agreement
    • Product Updates
    • Contact Support
  • Blog
    • 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
    • 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
    • SUMIF, COUNTIF and AVERAGEIF: conditional aggregates without extra columns
    • Reading Jira custom fields that the Jira Issues macro won't show you
    • Calculating one column from another: per-row formulas like price times tax
    • Adding a running total to any Confluence table
    • 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
    • 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
    • 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
    • Text highlight and replacement with CelesteCS Conditions
    • 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
    • Bulk-fixing sideways phone photos in Confluence without losing quality
    • Working with clones, duplicates and blockers using CelesteCS JQL Extensions
    • Flattening an Epic-and-Stories tree into one report with jqlx.flattenedTwoLevelTree
    • Finding issues that fell through the cracks with CelesteCS JQL Extensions
  • Company
    • About
    • Contact Us
    • SLA

Operations

The list of supported operations is now on the Functions page, in the Operations section above the function list.

  • Overview
  • How to start
  • Numerical Expression macro
  • Chart macro
  • Parameters
  • Operations
  • Functions
  • Adding Table Values as Operands
  • Adding Other Macros as Operands
  • Security and Privacy Statement
  • End User License Agreement
  • Migrating from Data Center to Cloud

Products

  • Conditions for Confluence
  • JQL Extensions for Jira
  • Math for Confluence
  • Reporting for Confluence
  • Rotator for Confluence

Support

  • FAQ
  • Documentation
  • Product Updates

Company

  • About

Contacts

  • info@celestecs.com
  • sales@celestecs.com
  • support@celestecs.com
 
 
Bootstrap is a front-end framework of Twitter, Inc. Code licensed under MIT License. Font Awesome font licensed under SIL OFL 1.1.