Calculate percent off another row in Jaspersoft server
Posted on January 7, 2014 at 7:13am
Hello,
i am trying to figure out how to calculate percentages based off different rows.
For example
My data looks like this:
| |
Team1 |
Team2 |
Team3 |
Totals |
| Ticket Count |
100 |
50 |
200 |
350 |
| % Of tickets |
28% |
14% |
57% |
100% |
| Number Resloved |
90 |
50 |
100 |
240 |
| % Resloved |
90% |
100% |
50% |
80% |
Any help on how to do this would be greatly appreciated.
Joined: Jan 3 2014 - 6:40am
Last seen: 9 years 4 months ago
Posted on January 16, 2014 at 4:51pm
Try using a table instead of a crosstab. You will need to have your teams as rows and your tickets as columns. Then you can right-click on each column one at a time and create a custom field for that column.
Joined: Mar 5 2012 - 9:19am
Last seen: 3 years 1 month ago
