Das Notes Forum

Lotus Notes / Domino Sonstiges => Projekt Bereich => Help-Desk Applikation !!Help!! => Thema gestartet von: alecrespi am 14.02.07 - 17:06:50

Titel: Statistic View (with partial and total)
Beitrag von: alecrespi am 14.02.07 - 17:06:50

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     |

Titel: Re: Statistic View (with partial and total)
Beitrag von: eknori am 14.02.07 - 17:23:58

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

Titel: Re: Statistic View (with partial and total)
Beitrag von: alecrespi am 15.02.07 - 09:29:17

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...
 :-:

Titel: Re: Statistic View (with partial and total)
Beitrag von: alecrespi am 28.02.07 - 14:35:21

Zitat von: eknori am 14.02.07 - 17:23:58

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.