Marc Powell
- Total activity 17
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 3
- Subscriptions 5
Activity overview
Latest activity by Marc Powell-
Marc Powell commented,
How do I collect from multiple blobs, but each collector sends to a different endpoint? I want to separate the two blob collections into their own sourceCategory
-
Marc Powell commented,
I changed my date format to yyyy-mm-dd to fix the issue
-
Marc Powell created a post,
Sorting by formatted date
I'd like to sort a box plot that's using a formatted date: The times are all muddled because formatDate converts the date to string Here's my query: _sourceCategory=production/web/* | formatDate(_...
-
Marc Powell commented,
So I appear to have inadvertently fixed this by myself by formatting the timeslice: | formatDate(_timeslice, "dd MMM yyyy") as Date| min(timetaken), pct(timetaken,25), pct(timetaken,50), pct(timeta...
-
Marc Powell commented,
_sourceCategory=production/web/* | formatDate(_messagetime, "EEE") as day | where !(day="Sat" or day="Sun")| timeslice 24h| min(timetaken), pct(timetaken,25), pct(timetaken,50), pct(timetaken, 99) ...
-
Marc Powell created a post,
Include full day's data in relative time search
I'm searching with a period of "-10d -1d", but this doesn't search from 12am on the earliest day. Is there a way I can search relatively, but search from 12am onwards on the earliest day? I want ...
-
Marc Powell created a post,
Exclude days with no data from box plot
We use Box Plot charts on our dashboard and we exclude weekends from the search, as follows: Is there any way we can clean up the chart and exclude these days from it? There don't seem to be a...
-
Marc Powell commented,
You're absolutely right, why didn't I think of that?! Thanks for the help, Kevin
-
Marc Powell created a post,
Use count by with multiple where clauses
I'd like to get the search values based on two where clauses. e.g. | where timetaken > 750 count by _timeslice and | where timetaken <= 750 count by _timeslice Is something along these lin...