Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
...
Excerpt | ||
---|---|---|
| ||
Evaluating Calculated Planned and Spent Time Per Assignee |
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.
Handy Tip | ||
---|---|---|
| ||
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 Column | Status |
---|---|
Filter Type | Dropdown |
Filter Values | Done |
Pivot Table:
Row Labels | Assignee |
---|---|
Column Labels | - |
Calculated Column | Original Estimate, Time Spent |
Operation Type | Sum |
Table Transformer:
Use the following SQL query:
Code Block | ||
---|---|---|
| ||
SELECT *, CASE WHEN 'Sum of Time Spent' > 'Sum of Original Estimate' THEN "OVERDUE" ELSE "IN TIME" END AS 'Time Evaluation' FROM T1 |
Handy Carousel |
---|
Image Removed |