Field = 1.123456789
Field = 14.123456
Field = 3.1234567
I need to run a query that will return the number of decimals for each record in Field.
Expected Result:
9
6
7
Hello everyone,
I have a field named SQL_NAME with values as per below (I'm writing two of them):
#1(8):EMEMEB #2(14):8/3/2022 0:0:0 #3(13):Ememe Behe #4(3):409 #5(0): #1(6):TSUDE #2(14):8/1/2...
...otal_count_for_this_month_div_by_num_of_days_with_events_for_this_month
So, for example
Jan 1=10 events
Jan 3=12 events
Jan 14=15 events
Jan 21=6 events
total events=43
average=10.75
Feb 1=13 events
Feb 3...
I am working to merge two searches. The first search outputs one or more account names:
index=x sourcetype=y
| table account
The second search (below), for eac...
I know that how to calculate max search concurrency in stand-alone is below.
normal search : max_hist_searches = max_search_per_cpu(* default is 1) * core + base_max_searches(* default is 6)
n...
I am trying to calculate a moving average and overlay those values on a bar chart of actual values. This is what I have:
| streamstats window=7 avg(Value) AS AvgValue | chart values(AvgValue) AS ...