Dashboards & Visualizations

Searching for a partial string in a loadjob

strehb18
Path Finder

Hello,

I generally use the following format to limit specific search results from panel to panel. However, in this case I would like to search for anything containing the string. 

[|loadjob $work_center_base$
| stats values(work_center) as location] 

This would limit the results in my search to only what is in the work_center field. I would like to match anything that contains what is in the location field. I won't this as the locations have more description after the work_center. 

ex:

work_center              

1CAP1
1CAP2
1CAP3
1CAP4

location  (examples to match) 

1CAP1-E3

1CAP2-W4

1CAP1-W1 

1CAP4-E1 ...

I am wondering if I can alter my search to match these and keep all locations that contain partials of work_center. 

Labels (3)
0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!