Evaluating Calculated Planned and Spent Time Per Assignee

Overview

                                                           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. 
5. Wrap the Pivot Table macro and the table containing statuses in the Table Transformer macro.

<div class="handy-tip-dialog wiki-content"> <p>If you don't need to have colorful statuses in the Time Evaluation column, don't add this single column table.</p> </div>

Macro configuration:

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