Department in charts - My Dashbords view

[Daniel]

Could we please have Department in the axis options in "My Dashboards" view charts?
 

Thanks
Daniel

[Steve Giller]

@Daniel Where are you storing the Department?

As far as I'm aware there isn't a field for "Department" (although you can store it in a Custom Field) and this would normally be an Organisation Record linked to a Customer, so not stored against the Request at all.

[Daniel]

Hi @Steve,

it is Organisation Record in Hornbill User profile

[Steve Giller]

Hi @Daniel

As suspected, this is not a field in the Requests table (or even a specific field) but a relationship specified by a linked table.

What you would need to do would be to use your Business Process to copy the Customer's Department from the Service Manager->Entity->Requests->Get Request Information->Customer Details node into one of the Custom Fields for the Request, and then use that Custom Field as the X-Axis.