This version of the app's documentation is outdated. Please find the information you're looking for here:



Evaluating Calculated Planned and Spent Time Per Assignee


The Source Table:

The Result:



Macro combination:

  1. Insert the Jira Issues macro.
  2. Wrap the Jira Issues macro in the Table Filter macro.
  3. Wrap the Table Filter macro in the Pivot Table macro.
  4. Add a table with a single column 'Time Evaluation' and containing the Status macros. (info)
  5. Wrap the Pivot Table macro and the table containing statuses in the Table Transformer macro.

If you don't need to have colorful statuses in the Time Evaluation column, don't add this single column table.


Macro configuration:

Table Filter:

Filter ColumnStatus
Filter TypeDropdown
Filter ValuesDone

Pivot Table:

Row LabelsAssignee
Column Labels-
Calculated ColumnOriginal Estimate, Time Spent
Operation TypeSum

Table Transformer:

Use the following SQL query:

SELECT *,
CASE WHEN 'Sum of Time Spent' > 'Sum of Original Estimate' 
THEN "OVERDUE" 
ELSE "IN TIME" END AS 'Time Evaluation'
FROM T1