<commit_before>Aggregate functions
===================
With SiriDB it's possible to request points for a time series and perform a function
on the data before returning the result. Although you could also request the original points
and perform your own functions on the data, using functions in SiriDB can save some network traffic.

For help on how to use functions see `help select`.

limit
-----
Syntax:

    limit(max_points, aggr_function)
    
Returns at most `max_points` and uses a given aggregation function to reduce
the number of points if needed.

Example:

    # Returns at most 100 points for 'my-series'. The original values are 
    # returned in case hundred or less points are found. In case more points 
    # are found a mean aggregation function is used.
    select limit(100, mean) from "my-series"

count
-----
Syntax:

	count(ts)

Returns an integer value.

Count can be used to calculate points over a period of time.

Example:

	# Get the number of points in 'series-001' over the past 24 hours.<commit_msg>Update help functions<commit_after>Aggregate functions
===================
SiriDB supports multiple build-in aggregation and filter functions. Using these functions can be useful to reduce network traffic. Note that multiple functions can be combined using the arrow `=>` sign. (see `help select` for more information on how to use and combine functions)

List of supported aggregation and filter functions:

limit
-----
Syntax:

    limit(max_points, aggr_function)
    
Returns at most `max_points` and uses a given aggregation function to reduce
the number of points if needed.

Example:

    # Returns at most 100 points for 'my-series'. The original values are 
    # returned in case hundred or less points are found. In case more points 
    # are found a mean aggregation function is used.
    select limit(100, mean) from "my-series"

count
-----
Syntax:

	count(ts)

Returns an integer value.

Count can be used to calculate points over a period of time.

Example:

	# Get the number of points in 'series-001' over the past 24 hours.
{'fraction_non_alphanumeric': 0.0731824747231584, 'fraction_numerical': 0.01059220028887819, 'mean_word_length': 3.7551487414187643, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 4, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6163356', 'n_tokens_mistral': 554, 'n_tokens_neox': 516, 'n_words': 295}