Strange.
stats sum(Households) should work, that is unless the main search is completely empty.
What 'illegal' message did that return? Can you paste it in?
As to the second postProcess, timechart span=1d sum(play_seconds_val) by ServiceName useother="f" -
Well this wont work because the final results for your base search doesn't have a field called play_seconds_val. You renamed it to PlaySeconds.
And the third postProcess, for one thing there's a typo -- PlaySecnds instead of PlaySeconds , and for a second problem indeed you need to have a function argument like distinct_count() or sum() or max(). You can't just specify raw field names.
... View more