Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
at script also:
LOAD *
FROM tablename
Where not [Job Name] like '*.B.11*';
hope this helps
regards
Marco
in script
load
*
from
<yourfileortable>
where not wildmatch([Job Name], '*.B.11*');
Hi,
Try something like as below in the script.
If(Index([Job Name], 'B.11'> 0, 'B.11') as [Job Name]
hope it helps!!
at script also:
LOAD *
FROM tablename
Where not [Job Name] like '*.B.11*';
hope this helps
regards
Marco