I am trying to count events where a field is in between a couple of ranges.
My field is detail.id which has the following format -> A1234567B
First thing I do is substring out the digits, then check if the digits are in certain ranges, and then count them.
baseSearch | eval id=substr(detail.id,2,7) | eval ps_id = if((id >= 2700000 AND id <= 2,704,999) OR (id >= 2730000 AND id <= 2735999), 1, 0) | stats sum(ps_id) as count
I am editing the source xml for a dashboard so when I try and save this, I get the following error:
Encountered the following error while trying to update: In handler 'views': Error parsing XML on line 77: StartTag: invalid element name
This seems to be something with the < since when I take it out, I can save it, but the search, however, doesn't work.
... View more