Combining batch and stream (or any alertnative)

Hi All,
Have a scenario. There is an influxdb configured with 4 columns and the data points are pushed regularly.
however, there is target, duration, files, bytes files in influxdb. for different targets there is different duration. i.e. target A has duration 200, target B has duration 100, target C has duration 150, target A has duration 100 and so on......
If there is new data point coming in with the target A with duration 150. I have take the standard deviation of duration of all the previous target A and compare the new duration with that standard deviation value.

target A 150
target A 100
target A 300
target B 100
target C 120

if the new data point comes in with target A 90,
have to compare like standardeviation of target A (150,100,300) and compare with 90 and throw an alerts in slack channel.
Please help in how to proceed with this scenario (batch or stream). A small pseudo of the tick script suggestion would be really helpful. Thank you.

Regards
Praveen

Start with the issue's InfluxDB data layout and the proposed batch-or-stream TICKscript scenario. Determine whether the requested per-target historical standard deviation and Slack alert are supported; done means a concrete documented approach or a clearly stated limitation.

Written by the indexing model from the issue text.