Statistic View (with partial and total)

[alecrespi]

How can I do to create a view (in the statistic tab) with only 1 row for each department and 2 columns with "open ticket" (total)  and "closed ticket" (total).

Something like...

|Department|Open |Closed|
|Dept1         | 5       | 10     |
|Dept2         | 3       | 15     |
|Dept3         | 0       |   8     |
|Dept4         | 10     | 32     |
|TOTAL         | 18     | 65     |

[eknori]

Notes can do a lot of tricks but I think Notes can't do this.

The easiest way to accomplish this would be to creat a new form type to store the values and an agent to do the search-and-summerize stuff.

The resulting docs can then be displayed in a view of your choice ...

just a suggestion

[alecrespi]

I'm just a little bit "far" from Agents...
 

would it be easier with the total of each "grouped category" between "(" and ")"
(inside existing view)?

like I supposed to do in a previous post...
 

[alecrespi]

The easiest way to accomplish this would be to creat a new form type to store the values and an agent to do the search-and-summerize stuff.
The resulting docs can then be displayed in a view of your choice ...

Hi!
If you have time, I'd like to know HOW to do this.
It seems very interesting.
thank you in advance.