| Warningmybanner |
|---|
This version of the app's documentation is outdated. Please find the information you're looking for here: |
| 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 |
|---|
|
| Excerpt Include | ||||||
|---|---|---|---|---|---|---|
|