Timelion sum metric by month

Hi,
I'd like to have Timelion use a data points that are a sum total for a given period like a month or a quarter. For example company Profit&Loss is reported monthly or quarterly but underlying data is at the granularity of daily P&L.

Using the sum metric the P&L reported is the sum of all daily P&L in the specified time period which is not what I'm looking for.

Any pointers would be greatly appreciated.

Thanks,
Sanjiv

Hi Sanjiv,

Your Timelion expression wil look like

.es(metric=sum:profit) .es(metric=sum:loss) 

Then you'll want to change the interval to 1M in the interval drop-down on the right side of the expression input box.

Perfect! I hadn't fully understood the significance of the time period on the Timelion search bar until now. Thanks!

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.