Is there a way to use Kapacitor to sort by a field and store the rank back as a field?
I have a tick script which is using a window to sum the number of events over the last 24 hour for several thousand entities every 5 minutes and store this back into InfluxDB. I would also like to store the position of each entity when they are sorted by this value.
I’m hoping there’s a way within Kapacitor to do this. If not is can I somehow subscribe to this data from Kapacitor, sort it myself and then post new entries into InfluxDB?