Table Filter, Charts & Spreadsheets for Confluence How to work with built-in and third-party macros Jira Issues Current: Evaluating Calculated Planned and Spent Time Per Assignee PDF Download PDF Download page Evaluating Calculated Planned and Spent Time Per Assignee. Current page All pages Evaluating Calculated Planned and Spent Time Per Assignee Overview The Source Table: The result: Macro combination:Insert the Jira Issues macro.Wrap the Jira Issues macro in the Table Filter macro.Wrap the Table Filter macro in the Pivot Table macro.Add a table with a single column 'Time Evaluation' and containing the Status macros. 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 Filter: Filter ColumnStatusFilter TypeDropdownFilter ValuesDonePivot Table: Row LabelsAssigneeColumn Labels-Calculated ColumnOriginal Estimate, Time SpentOperation 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 SQL ×