Wido

Hi,

I used a calculated attribute to create a data filter for my dashboard. It is not an ideal solution but it beats manually selecting all the names from a very long list of users.

It basically gives me a list of all the active agents. This excludes expired agents whose accounts were converted back to end-users or deleted. 

The downside of this method is that you have to do it for every data set and the field names are different for each set. This particular example is from the ticket updates data set. 

IF ([Assignee role] = "Agent") 
    AND ([Assignee status] = "Active")
    THEN
    [Assignee name]
    
ENDIF