Axibase Time Series Database - report of hits per hour -
    i using axibase time series database community edition, version 11499, store count every time hit particular web service.  how can report of hits per hour last 7 days?          you can use of of 2 built-in aggregation  functions compute rate of change on period of time: delta , counter.   here examples:    example 1  example 2    as can see, difference in how these functions handle resets. counter function works particularly continuously incrementing metric might reset (drop 0 or negative value) in case of data type overflow or restart.