time-seriesaxibase

Axibase Time Series Database - report of hits per hour

I am using Axibase Time Series Database Community Edition, version 11499, to store a count every time we hit a particular web service. How can I get a report of hits per hour for the last 7 days?

Solution

  • You can use of of the two built-in aggregation functions to compute a rate of change over a period of time: DELTA and COUNTER.

    Here are some examples:

    As you can see, the difference is in how these functions handle resets. The COUNTER function works particularly well for a continuously incrementing metric that might reset (drop to 0 or a negative value) in case of data type overflow or a restart.