Grouping blocked traffic every 5 second intervals using timestamp.

KNIME Extensions
#1

Need help grouping blocked traffic every 5 second intervals using timestamp using KNIME.

Tables include:
access column = block for incoming traffic
timestamp column = 2022-10-13T17:55:23.002Z (example of format)

Again, we want to calculate the blocked traffic per 5 seconds.

For example, we want something that tells us 2 blocks per 5 seconds. Any help is appreciated! Thanks

#2
  1. Map timestamp to the desired interval, e.g. by using divide and floor
  2. Use GroupBy combined with e.g. count aggregation to count the events per each interval
1 Like
#4

Could you possibly explain a little more, new to KNIME. Thank you! Please help

#5

Please post some example data and/or your current version of the workflow. If not me, Iā€™m sure someone else will step in.

1 Like
#6

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