Hello @gcusello
Thanks for your reply.
But I have following queries
Can you please verify the now below code is ok ?
Last 4 weeks
Unique-Sessions
index=xxxx namespace=yyyyyy* container_name=zzzzz
| eval day=strftime(_time,"%F")
| bin _time span=1w
| stats dc(ctxSessionID) AS Unique_Session, dc(day) as days BY _time
| eval Avgerage_Per_Day=Unique_Session/days
1
-4w@w
now
0
auto
collapsed
collapsed
auto
auto
auto
linear
column
all
default
none
0
0
ellipsisEnd
top
Also I am trying to find the average value of unique session for each week. But I am not sure what I am doing wrong here.
_time Unique_Session days Average_Per_Day
2020-01-12 9154 7 1307
2020-01-19 8669 6 1444
for example it started counting the day from last Sunday 2020-01-19 instead of current week Monday.
my expectation
_time Unique_Session days Average_Per_Day
2020-01-13 9154 7 1307
2020-01-20 8669 5 1733
... View more