Hello everyone! I am looking to remove duplicates in my influxDB database for a certain timerange. I have the TRAFFIC to a number of different locations as my influxDB data. The API I am using gives me the traffic data for those locations in realtime - meaning I have to keep calling the API every X period and store the traffic.
Right now, i am calling the API and storing the data every 30 seconds. What’s happening is people who are already in those locations are being added every time the data gets stored. I want to filter out all those duplicates in a 10 minutes time range (I am willing to count someone’s traffic TWICE if they stay for more than 10 minutes in a place). How would I go about doing this? I haven’t been able to figure out the process. I would really appreciate if someone could assist.
The traffic is for a virtual game. There are different locations in that virtual world and I am creating a traffic database for that virtual world, to find the highest visited places, etc.
So basically, what I am willing to do - is somehow filter check that how many individuals who stayed on the same location for less than 10 minutes (meaning there are multiple data points for that individual in that 10 minute data) and remove those data points.