New View grouped by "Department"

[alecrespi]

Hi!
I've created a new view called "Closed by Department".
I would like to have all the Closed Ticket grouped by Department.

Is there any variable or field in the HELPDESK database that would help me in doing this?
or do I have to caluclate the Department using "username" and the Public Address Book (names.nsf)?

[alecrespi]

I would like to use a field like
"department"
in the form HD Anfrage

but I'd like to use it a sorting column inside a view...

[Thomas Schulte]

In the ticket you have got a department field. This one is Computed for Display. If you change it to Computed you will be able to use it in your view.
Keep in mind that this has one effect. The next update will changes this field to CFD again.

[alecrespi]

I've got it...
GREAT!
 

[alecrespi]

another question linked with this one...
 

How can I do to show the number of documents in each "department" group?
just to see which departments wins the "helpdesk prize" of the year...
 

Can I use the @Count function?
If I use the "Total" checkbox in Property box I get a "0" as count.

[alecrespi]

I would like to have a situation like this...
with the total of each "grouped category" between "(" and ")"

[Hagen-Roderich]

Ich steh vor dem gleichen Problem und will mit @Count einige Sachen zählen lassen. Die Notes Hilfe hat mich leider nicht weitergebracht.
Ich will zum Beispiel das in der Ansicht "Tickets in Bearbeitung / nach User" hinter dem Username in Klammern die Anzahl der offenen Tickets steht. Wie muss der Code dafür aussehen?

[Thomas Schulte]

In Klammern dahinter geht gar nicht.

Was du tun kannst ist eine neue Spalte als Summenspalte anlegen und in diese Spalte einfach eine 1 reinschreiben.

[Hagen-Roderich]

Danke, funktioniert.