Hi,  I have data like A-001, A-002, A-003..... I would like to know how to extract the numbers from these strings: 001, 002, 003....so that I can generate an alert: every three batche (001, 004, 007) should be check. Can someone help me with that? Thanks1   Regards, Tong  ... View more

Hi,  I habe a table after using stats: | stats values(durationSum) as duration by Fauf Station. How can I convert it to a table with only one line in such a format: Fauf duration_Station1 duration_Station2, duration_Station7, duration_Station10 Thanks for helping in advance!     ... View more

Hi,  I would like to monitor one value of each event. When it keeps increasing after 5 events, an alarm should be triggert.  I uase autoregress to generate the difference between the current event and previous event (see below). But how can I monitor that the difference keeps being positive after five events? Thank you very much! | autoregress C_avg as C_avg_prev | eval C_detal=C_avg-C_avg_prev   ... View more

Hi,  I have 3 products 1, 2, and 3, each of them contain several elements a, b c, d. Each product has different specification depending on the elements % Product 1:  a1<a<a2, b1<b<b2, c1<c<c2 Product 2:  a3<a<a4, b3<b<b4, d3<d<d4 product 3: a5<a<a6, b5<b<b6, c5<c<c6, d5<d<d6 I would like to have a list  Product , a, b, c, d, In_Spec I would like to use eval to assign the value to In_Spec |eval In_Spec=( if Product=1 and  a1<a<a2 and b1<b<b2 and c1<c<c2, "yes", "no") but How can include product 2 and product 2? In the end I want sth like: |eval In_Spec=( if Product 1.......... Product2........... Product 3............"yes", "no") can someone help me with that? Many thanks in advance! ... View more

Hi,  I have three visualisation elements: one table and two panels with single numbers. These three are now next to each other. I would like to put Table on the left and the other two panels vertically stacked on the right hand. Below is the source code. Can anyone help me out? Thanks in advance! <panel> <table> <title>xx</title> <search> <query>........</query> <earliest>........</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name=..........</option> </table> </panel> <panel> <single> <title>.......</title> <search> ......... </search> <option name=................</option> </single> </panel> <panel> <title>.........</title> <single> <search>...............</search> <option name="....................</option> </single> </panel> ... View more

I have under each orderNr five different weights. __________________________ Weight: 0.898, WeightTypeId: 1, OrderNr: 8478 Weight: 0.094, WeightTypeId: 2, OrderNr: 8478 Weight: 7.45, WeightTypeId: 3, OrderNr: 8478 Weight: 0.0, WeightTypeId: 4, OrderNr: 8478 Weight: 7.45, WeightTypeId: 5, OrderNr: 8478 ............................... ___________________________________ I would like to calculate the total weight and the yields, which is calculated like this:  Total:  Weight(WeightTypeID1) + Weight(WeightTypeID2) +Weight(WeightTypeID4) +Weight(WeightTypeID5) Yield1 = Weight (WeightTypeId 1)/ Total Yield2= Weight(WeightTypeID3)/Total I am thinking of using eval to assign the Weight (under WeightTypeId1) to weight 1, weight 2, weight 3.... Then it is easy to do the calculations.  |Eval werigh1= if (WeightTypeId=1, Weight, 0). But somehow I feel this is not correct... Can someone help me with that? Thanks a lot!     ... View more