Table transformer to add new column in the middle

[emagnun]

I want to show Jira Sprint tasks overview in confluence. Below is my source table and the result of table transformer that already has most of what I wanted. I will NOT display source table to user.

Question: how do i modify my table transformer to add one more column !done to show unfinished tasks count (To do + In Progress)? Is it possible to add it right after Sprint column? Below is my current SQL query.

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @emagnun ,

Please check if this solution suits your case:

SELECT T1.'Sprint',
(T1.'Sum of Status To Do' + T1.'Sum of Status In Progress') AS 'Not Done',
T1.'Sum of Status Done' AS 'Done',
T1.'Sum of Status T:' AS 'Total',
ROUND((T1.'Sum of Status Done'*100)/T1.'Sum of Status T:',2) AS 'Completion %'
FROM T1

[emagnun]

Thanks @Katerina Kovriga _Stiltsoft_