About strehb18

strehb18 · ‎12-08-2021

Hello, I am wondering what the best way to find a value in one my fields matches what is in a mv field. I cannot use mv expand and a where due to the storage limit I encounter. Is there a way to show that "match" matches with the values in field2, but "miss" would not.

strehb18 · ‎10-28-2021

I can send more specific input if needed.

strehb18 · ‎10-27-2021

Hello, I am working with a large form that essentially takes inputs and creates a record of scan. The part I am focusing on is a set of two inputs that I pass as tokens into a search that at the end runs a collect function. The problem I am running into is that after I enter a value in the first input and tab into the next input. It seems the function runs. This is causing the second input to not be collected in the data unless is quickly enter and tab out of the input box. If I can do it quickly, the value is getting passed. It will not pass a value if the second input is entered but still clicked on. Is there anyway to halt the collect function until both inputs are entered?

strehb18 · ‎10-21-2021

My current efforts of <unset/> and <unset></> have not worked. Do you have an example of how to structure the token setup in the drilldown?

strehb18 · ‎10-21-2021

Hello, In the past, I have used the checkbox method to hide panels after opening new ones. In this example, I would like to have a panel disappear after I click on the values in the panel. Currently, my next panel appears on the click, but the existing panel still exists. I'm wondering if there is any way to hide the panel that exists after i click on what I want to pass as the token. XML preferred.

strehb18 · ‎05-27-2021

Hello, I am having an issue with my data being changed from what exists. Is there potentially a field limit on dashboards? I am using a chart command by work_center and two of my work_center's are getting cut off and the information is being put under "OTHER". The line of code in subject is: | chart values(measure) over statistic by work_center Here is two pictures to prove things exist beyond 1CAP7.

strehb18 · ‎04-15-2021

Hello, I have been searching for a post similar to mine and just have not found it. I have to add some user inputs to a search. The process is we are assigning gps units to specific serial numbers for tracking purposes. The gps unit will be put on a product then removed when the product leaves one of our facilities. I would like to be able to barcode scan the unit then barcode scan the serial number and have it be in my searches. I threw together a lookup file to do this, but I feel like there is a better way to do this. The only references i would really need are the gps_id and the serial_number. I'll gladly give more description as necessary. I'm only partly familiar with more advnaced html, css, and js.

strehb18 · ‎02-10-2021

Hello, This is a follow up post to my recent post on "Trouble with Hidden Panel Passing Value". I am having an issue with the safety ticker that I had implemented in that question. For some reason, the only result being posted is <news ticker>. The code is below. For some reason this code was working but now is not. The point of the search is to produce one result that shows the last safety incident but only in the last 48 hours. The ticker itself uses a marquee to show the results. <form> <search> <query> index=defmfg_safety work_center="S1**" | sort 0 -_time | dedup id | head 3 | stats max(corrective_actions{}) as corrective_action by investigation_result | eval corrective_action=if(corrective_action="30 day follow up" OR corrective_action="6 month follow up","PENDING",corrective_action) | eval result=investigation_result +" -CORRECTIVE ACTION- "+ corrective_action | eval ticker=result | eval length=ceil(len(ticker)/2) . "ms" </query> <earliest>-48h@h</earliest> <finalized> <condition match="$job.resultCount$ == 0"> <unset token="ticker"></unset> <unset token="ticker_result"></unset> </condition> <condition> <set token="ticker">$result.ticker$</set> <set token="ticker_result">$result.result$</set> </condition> </finalized> </search> <row depends="$ticker$"> <panel> <html> <style> #marquee { font-size: 30px; color: white; height: 45px; white-space: nowrap; line-height: 60px; } h2 { font-size: 30px !important; text-align: center; padding: 5px !important; color: red; } </style> <h2>SAFETY ALERT</h2> <marquee scrollamount="19" id="marquee">$ticker$</marquee> </html> </panel> </row> </form>

strehb18 · ‎02-01-2021

I am once again having issues with this code. For some reason this works, and then will stop working. Here is the entire code if that helps. I am wondering where the disconnect maybe. I can make a table and pass the value and it shows. <search> <query> index=defmfg_safety work_center="MAIN*" | sort 0 -_time | dedup id | head 3 | stats max(corrective_actions{}) as corrective_action by investigation_result | eval corrective_action=if(corrective_action="30 day follow up" OR corrective_action="6 month follow up","PENDING",corrective_action) | eval result=investigation_result +" -CORRECTIVE ACTION- "+ corrective_action | eval ticker=result | eval length=ceil(len(ticker)/2) . "ms" </query> <earliest>-48h@h</earliest> <finalized> <condition match="$job.resultCount$ == 0"> <unset token="ticker"></unset> <unset token="ticker_result"></unset> </condition> <condition> <set token="ticker">$result.ticker$</set> <set token="ticker_result">$result.result$</set> </condition> </finalized> </search> <row depends="$ticker$"> <panel> <html> <style> #marquee { font-size: 30px; color: white; height: 45px; white-space: nowrap; line-height: 60px; } h2 { font-size: 30px !important; text-align: center; padding: 5px !important; color: red; } </style> <h2>SAFETY ALERT</h2> <marquee scrollamount="19" id="marquee">$ticker$</marquee> </html> </panel> </row>

strehb18 · ‎01-11-2021

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.

strehb18 · ‎12-23-2020

So I guess that is what my problem is. After the next event is added, the count changes. I could make it static but then wouldn't be able to tell when events are at certain spots. So I was wondering how to log a time when each event reaches the count of a certain number. So something like, looking at two different scenarios where we collect the _time when a count reaches 3. _time WO Count time_to_log 9:15 1234 1 9:00 1233 2 8:45 1232 3 9:15 8:30 1231 4 9:00 Next Event comes _time WO Count time_to_log 9:30 1235 1 9:15 1234 2 9:00 1233 3 9:30 8:45 1232 4 9:15 8:30 1231 5 9:00

strehb18 · ‎12-22-2020

This works for when looking at one specific record. What I am looking for is to record the _time when a work order reaches at specific count number. I would like to record the _time when a WO hits count=6, count= 12, count = 18.... etc to record when the work order hits certain spots on the count. The problem is my dataset records them just when they begin the work order. So ideally, I'd have the time at specific count numbers, but the only way I can tell when that time would be is by when the most recent one starts.

strehb18 · ‎12-21-2020

Hello, I am hoping this is easy and I am blanking. I have a data source the logs what work order is in station one. I am looking to get an offline_time based on when a work order reaches a certain station. Ex _time WO count 11:45 1231 1 11:40 1232 2 11:35 1233 3 11:30 1234 4 ..... etc So the _time is when the work starts and when count reaches a certain number, the work order would be done on the line(count would equal 35 in my case) . I would like to collect the _time of what is in count=1 when the count reaches 35. Thanks.

strehb18 · ‎12-01-2020

That is mostly correct. I would like to search production_area=$production_area$ unless a sub_production_area is not at the default. Then I would like to search production_area=$sub_production_area$. Thinking about it now, the ideal solution would be to add the subs into the production_area dropdown, but I don't want all that clutter in the dropdown. | search index=def_mfg source=work_order production_area=$select_production_area$ Is the main search. The tokens are created through inputs. I can put those in but they will fill the page a bit.

strehb18 · ‎11-30-2020

Hello, I am trying to find the best way to change my search based on a token value that I will pass through an input. Right now, I have a search that is filtered by a production area. I would like to be able to in that search, use the sub production area instead if one is selected. Both of these values have a token associated with them. $production_area$ and $sub_production_area$. I couldn't get a conditional in a search to work. I would only like to search based on the sub production area if a value other than the default is selected. The current search limits results by production_area=$production_area$. I can provide more information if needed. I had trouble wording the question to fully explain what I am looking for.

strehb18 · ‎11-10-2020

Sorry for the delay. This seems to be working. Any chance you can explain why what I had didn't work and what you wrote did work? I'd like to learn but also maybe make it applicable in different scenarios.

strehb18 · ‎10-29-2020

Hello, I am having trouble with a panel staying hidden when the search above shows no results. I would like to create a ticker of sorts that will display the result from a search. If something has happened in the last 48 hrs it will show, if not it will be hidden. I was told to try the below from a different source but it's not quite working to hide when there are no results. The search itself works, but the ticker is showing at all times. <search> <query> search that will return one result ( a string) or no results </query> <earliest>-48h</earliest> <finalized> <condition match=" 'job.resultCount' != 0"> <set token="ticker">$result.ticker$</set> <set token="ticker_result">$result.ticker$</set> </condition> <condition match=" 'job.resultCount' = 0"> <unset token="ticker"></unset> <unset token="ticker_result"></unset> </condition> </finalized> </search> <row> <panel depends="$ticker$"> <html> <style> #marquee { style: choices } </style> <marquee scrollamount="19" id="marquee">ALERT - $ticker_result$</marquee> </html> </panel> </row>

strehb18 · ‎10-27-2020

Hello, I am trying to add a break time into a cycle time that I am tracking. So the _time field pulls when the start of a cycle is. I have been using the delta function to gather the duration between the cycles. The problem that I am running into that the cycles stay on during breaks and lunch time which will add 15 or 30 minutes to the cycle time. I am hoping this is something east to account for. The problem in my mind is that I want the solution to be scalable to multiple days. I am looking to add 15 minutes to any cycle that was started from 8:50-9:15 or 30 minutes to something 11:50-12:30. An example from the data _time duration 2020-10-26 12:40:32.593 -0.003 2020-10-26 12:40:32.577 -0.016 2020-10-26 12:35:29.080 -303.497 2020-10-26 12:35:29.058 -0.022 2020-10-26 12:35:28.967 -0.091 2020-10-26 12:30:25.567 -303.400 2020-10-26 12:30:25.547 -0.020 2020-10-26 11:50:01.608 -2423.939

strehb18 · ‎10-19-2020

Yes! This worked for my data. Thank you for all the help.

strehb18 · ‎10-19-2020

I get the same error without the space.

Posts	27
Solutions	0
Karma Given	5
Karma Received	6
Member Since	‎10-01-2020

Online Status	Offline
Date Last Visited	4 weeks ago

Best Way to Find if Field Matches a Value in an MV...

Two Inputs Sending to a Collect Function

Hiding Panels After Unhiding a New Panel

"OTHER" being presented in a CHART function

Adding User Inputs into searches

Trouble With Ticker Not Populating

Searching for a partial string in a loadjob

Collecting _time from a different event

Best Way to Search based on a Token Value

Trouble with Hidden Panel Passing a Value

Best Way to Find if Field Matches a Value in an MV...

Re: Two Inputs Sending to a Collect Function

Two Inputs Sending to a Collect Function

Re: Hiding Panels After Unhiding a New Panel

Hiding Panels After Unhiding a New Panel

"OTHER" being presented in a CHART function

Adding User Inputs into searches

Trouble With Ticker Not Populating

Re: Trouble with Hidden Panel Passing a Value

Searching for a partial string in a loadjob

Re: Collecting _time from a different event

Re: Collecting _time from a different event

Collecting _time from a different event

Re: Best Way to Search based on a Token Value

Best Way to Search based on a Token Value

Re: Trouble with Hidden Panel Passing a Value

Trouble with Hidden Panel Passing a Value

Adding in a break/lunch time into a duration

Re: Question for extracting a string out of longer...

Re: Question for extracting a string out of longer...