3 Replies Latest reply: Sep 29, 2014 6:21 PM by Marco Wedel RSS

    How to filter records with specific words/numbers/etc. through the script/chart properties?

      One of the dashboards I'm creating uses 'Job Name' as a dimension, but not all the job names are relevant to the report.

       

      A particular instance of "Job Name" includes the job title and job code. For example, "Shipping Manager .C.85" or "Material Coordinator .B.11".

       

      I want to filter out any result that has ".B.11" in the "Job Name" field from showing up in any charts, list boxes, tables, etc. Is there a way to do this through the script or chart properties?

       

      Thank you