I wanted to add the following to my SQL query (I use Confluence->Table Transformator): I wanted to output the total number of G1 projects and separately the total number for G2 projects. Can I still add this to my code? Now I only get a 1 for each line, but unfortunately that doesn't give me the total number of G1 or G2. I've been working on it for so long, please help me.
This is my current code :
"
SELECT *, COUNT(*) AS 'Projekte', T1.'Key'
FROM
(SELECT
CASE
WHEN T1.'Labels' LIKE "%G1%"
THEN FORMATWIKI("{cell:bgColor=#00FF00}G1{cell}")
WHEN T1.'Labels' LIKE "%G2%"
THEN FORMATWIKI("{cell:bgColor=#FF0000}G2{cell}")
END AS 'Milestone', 'Key'
FROM T*) T
WHERE T.'Milestone' IS NOT NULL
GROUP BY T.'Milestone', 'Key'
ORDER BY Projekte ASC
"
Hi @Jovan Aks ,
The Table Transformer macro is provided by our app that is Table Filter, Charts & Spreadsheets for Confluence. So, you may check this part of our documentation that shows how to count definite values in a column: https://docs.stiltsoft.com/tfac/dc-server/custom-transformation-use-cases-with-advanced-sql-queries-42241587.html#CustomTransformationusecaseswithadvancedSQLqueries-Countingthedefinitevalueinacolumn
If you are still stuck, you may refer to our support portal that is confidential. There you may share your page storage format (upper right corner of the page -> menu ... -> View storage format) and the screenshot of your Jira Issues table and we'll help you with the case.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.