So... I have a weird one I can't seem to find much info on.
I want to use the per_second() command, but i want a sum of it's results. The real scenario is complicated but for simplification lets say we have csv data that returns:
_time,feet,name
###,100,steve
###,70,bob
###,200,steve
###,120,bob
and i want to know the feet per second, by name.
timechart per_second(feet) as Fps by name
no problem. makes a nice chart of feet per second, by name, for each time tick. but what i want is a table, that shows a sum of:
Name Fps
------------
Bob 23
Steve 42
(numbers in that example made up)
when i try to do:
timechart per_second(feet) as Fps by name | stats sum(FPS) by Name
i get zilch.
... View more