About crmarley20

crmarley20 · ‎02-13-2022

Thank you very much!

crmarley20 · ‎02-13-2022

I am sorry, next time I will write the text, thank you very much for your answer.

crmarley20 · ‎02-09-2022

Hello, I need your help please, I have two tables resulting from two searches and I need to join these two tables to make a cumulative bar chart according to date. My tables are What I want to achieve is: Datum A1 A2 A3 A4 A5 A6 2022-02-08 5.7 3.7 1.9 4.56 90.3

crmarley20 · ‎02-09-2022

I solved it, thank you very much for your support. In my real case I have more columns so what I have done is to sort each row by Begin End and the error number (it happens that the error number of the message "Techn. did not write" is 8000000 while the type of reason have error numbers less than 100. With the data sorted, I applied dedup with the Begin End and Technician fields. Thank you very much for your help.

crmarley20 · ‎02-09-2022

It does not always work, I have tested it in my real case and it does not work well. Is there another solution?

crmarley20 · ‎02-09-2022

Hello, Please I need your help, I have a dedup with a conditional. It happens that I have this table where when the technician enters the reason for its technical service is saved in splunk its previous value and the new change. I need to delete the repeated rows and only keep the values that have a reason written by the technician.

crmarley20 · ‎02-09-2022

Hello, I need your help please, it happens that I have this table where when the technician enters the reason for its technical service is saved in splunk its previous value and the new change. I need to delete the repeated rows and only keep the values that have a reason written by the technician.

crmarley20 · ‎02-01-2022

Thank you very much!

crmarley20 · ‎02-01-2022

Hello, I have a condition when the variable new_tag of the previous row is equal to 1 and the variable test_tag of the current row is equal to 1 I must subtract the start value of the previous row with the start value of the current row. I want the result of the subtraction to be written in the previous row in the result column. Unfortunately I could only get this subtraction to be written to the current row in the result column. Please could someone help me, thank you very much.

crmarley20 · ‎01-19-2022

Hi, I need to sum the values of durations found in the Duration_of_Errors column of each error that occur in a user in a certain work shift of the day. I am using the stats command. It happens that the names of my errors start like this: Technical/broken screen Technical/keyboard crashed ... Organizational/absence of personnel Organizational/change of office ..... Quality/Audit Quality/server migration ..... I want to sum the duration of each group of errors per shift and user I have used this but I can't get it to sum, what am I doing wrong? | stats sum(eval(if(Error_Text="Technical*"))) as sum_technical_duration_errors by shift user Thanks in advance!

Posts	10
Solutions	0
Karma Given	4
Karma Received	1
Member Since	‎01-19-2022

Online Status	Offline
Date Last Visited	‎02-13-2022 06:13 AM

Joining Tables

How to delete the repeated rows and only keep the ...

How to delete repeated rows and only keep the valu...

how to move a value into adjacent row

Wildcard text in a sum(eval(if script

Re: How to delete repeated rows and only keep the ...