I have a set of data that I am averaging weekly using eval week=strftime(_time,"%Y-%U") . I then display this using chart values(foo) by week, bar .
However, I'd like to replace the week column with the date of the Monday of that week when it is displayed in the table. I would still like the data to be sorted by week still, but I do not want the week number to be displayed, only for that Monday of that week to be displayed. Thanks.
I wanted to generated a the Day1ofWeek column and appendcols to my search query but just generating a Day1ofWeek column with my query doesn't work.
What do you mean by "requires field _time to be available before this command"? Does that mean that I cannot use _time in my eval week statement?
... View more