Can i know the total number of events for a step value

31 views
Skip to first unread message

ADITYA ANANTA RAMAN

unread,
Oct 30, 2014, 4:04:02 AM10/30/14
to cube...@googlegroups.com
Hi,

I am using cube for retrieving metrics( using median) of events. Presently i am getting timestamp and median value. Is there anyway of getting number of events used to calculate the median value?

I am querying for a median, for a step of 5mins, There will be many events in that 5mins time range, but i ll get only one median value of all those events. So can i get total number of events in that time range along with the median value?

Thanks in Advance

Christian G. Warden

unread,
Oct 31, 2014, 12:18:04 PM10/31/14
to cube...@googlegroups.com
sum(event_type) will give you the number of events. If you query for
median(event_type(value)) and sum(event_type) using the same step, you
can associate the number of events with the median by timestamp.

Christian
Reply all
Reply to author
Forward
0 new messages