Hi guys,
I am trying to make a table showing number of tickets opened/closed since 2026-01-01, and made two different bar charts
- Created >= ‘2026-01-01’
- Created >= ‘2026-01-01’ AND Resolved >= ‘2026-01-01’
Initially wanted make each month showing both Opened/Resolved, however I couldn’t make it due to RT limit (I guess).
When I created these bar charts it automatically generated small table right next to bar chart as well, then it looks like
| **
| Created Month** | Ticket count |
|---|---|
| Jan | 11 |
| Feb | 22 |
| Mar | 23 |
| Apr | 23 |
| Total | x | | | |
| | | | | | | | |
|—:|----|----|----|----|----|----|----|----|----|----|----|----|----|
I wanted to make a table like this, but seems like it’s impossible because of the Calculate: only shows either ‘ticket count’ or amount of the time working on ticket (create-start, create-resolve..)
| Month | opened | closed |
|---|---|---|
| Jan | 10 | 3 |
| Feb | 8 | 9 |
| Mar | 6 | 12 |
Is there any way to make a table like this or is it just impossible in RT?