---
title: "Opened vs Resolved Issues Report Transposed"
canonical: "https://support.appfire.com/space/PSJ/15482454/Opened%20vs%20Resolved%20Issues%20Report%20Transposed"
format: markdown
---
> Macro (aura-html)


<span style="color: #172b4d">Another feature that comes out of the box with the help of </span> [silreporting_transposeTable](https://appfire.atlassian.net/wiki/spaces/PSJ/pages/15482590/silreporting+transposeTable) <span style="color: #172b4d"> function is the ability to transpose the table adn add custom headers after performing the operation. </span>

|  |
| --- |
| `string [] projects = argv[` `0` `];`   
 `string [] resolvedIssues;`   
 `string [] openedIssues;`   
 `for` `(string p in projects) {`   
 `    ` `resolvedIssues[p] += countIssues(` `"project = "` `+ p  + ` `" AND status in (Done, Closed, Resolved)"` `);`   
 `    ` `openedIssues[p] += countIssues(` `"project = "` `+ p  + ` `" AND status not in (Done, Closed, Resolved)"` `);`   
 `}`   
 `    `   
 `SILReportingHeader [] headers;`   
   
 `SILReportingHeader h1;`   
 `
            `[h1.name](http://h1.name)` = ` `"Opened Issues"` `;`   
 `h1.sortable = ` `"sortable"` `;`   
 `h1.color = ` `"white"` `;`   
 `h1.bgColor = ` `"#79aadb"` `;`   
 `headers += h1;`   
 `    `   
 `SILReportingHeader h2;`   
 `
            `[h2.name](http://h2.name)` = ` `"Resolved Issues"` `;`   
 `h2.sortable = ` `"sortable"` `;`   
 `h2.color = ` `"white"` `;`   
 `h2.bgColor = ` `"#79aadb"` `;`   
 `headers += h2;`   
   
 `string [][] rows;`   
 `for` `(string p in projects){`   
 `    ` `rows += {openedIssues[p], resolvedIssues[p]};`   
 `}`   
   
 `SILReportingTable table;`   
 `table.headers = headers;`   
 `table.rows = rows;`   
   
 `SILReportingHeader [] transposedHeaders; ` `// the headers of the transposed table(if it has any business meaning otherwise it can be left empty)`   
 `for` `(string p in projects){`   
 `    ` `SILReportingHeader h;`   
 `    ` `
            `[h.name](http://h.name)` = p;`   
 `    ` `h.sortable = ` `"sortable"` `;`   
 `    ` `h.color = ` `"white"` `;`   
 `    ` `h.bgColor=` `"#79aadb"` `;`   
 `    ` `transposedHeaders += h;`   
 `}`   
 `table = silreporting_transposeTable(table, transposedHeaders); ` `//transposing the table`   
   
 `return` `table;` |

![image](media://d3d5ed8a-470c-424f-96bc-286e8eafd336)

<span style="color: #333333"> </span>  
<span style="color: #333333">Now you can see all the projects and the issues that are in </span><span style="color: #333333">**Opened**</span><span style="color: #333333"> status and </span><span style="color: #333333">**Resolved**</span><span style="color: #333333"> status but as a transposed table. </span>  
<span style="color: #333333"> </span>