1 2 Previous Next 20 Replies Latest reply on Aug 31, 2017 6:27 AM by Christopher Carucci

    Filter Dashboard based on User department

    Christopher Carucci

      I've been trying to filter a dashboard based on user information that views it.  Right now I have a calculated field which will tell me what Business they are in.  In this example "SuperBusiness".  If they user is a member of "Business" = "SuperBusiness" then calculated field "IsSuperBusinessUser" = True.  This part works.

       

      Where I am stuck is I cannot figure how to use this to filter now.  We only want to show SuperBusiness data.  The dashboard has access to the entire data set of all businesses.  The field "user.businessDescription" is in every record.

       

      So I am trying to set this filter to only show "SuperBusiness".  It doesn't like my formula.

       

       

      It says the formula must be a Boolean formula.

        1 2 Previous Next