# \#tickscript

**URL:** https://community.influxdata.com/tag/tickscript/87.md

[Latest](https://community.influxdata.com/latest.md) · [Categories](https://community.influxdata.com/categories.md) · [Tags](https://community.influxdata.com/tags.md)

---

## [Kapacitor .id() field limitation in alert node partitioning issues with Kafka](https://community.influxdata.com/t/kapacitor-id-field-limitation-in-alert-node-partitioning-issues-with-kafka/57561)

<div class="topic-metadata">

**Author:** [@Husnain](https://community.influxdata.com/u/Husnain)\
**Replies:** 0\
**Last updated:** [July 7, 2025, 5:43pm UTC](https://community.influxdata.com/t/kapacitor-id-field-limitation-in-alert-node-partitioning-issues-with-kafka/57561 "2025-07-07T17:43:53Z")

</div>

:pushpin: Environment Kapacitor Version: 1.7.7 Deployment: Docker container Output Handler: Kafka (.topic() used to send alerts) Alert Streams: Multiple alert branches (flat\_threshold, analytic, etc.) Kafka Setup: 4…

---

## [Comparing current value to weekly minimum value](https://community.influxdata.com/t/comparing-current-value-to-weekly-minimum-value/33863)

<div class="topic-metadata">

**Author:** [@Quipex](https://community.influxdata.com/u/Quipex)\
**Replies:** 0\
**Last updated:** [April 8, 2024, 11:01pm UTC](https://community.influxdata.com/t/comparing-current-value-to-weekly-minimum-value/33863 "2024-04-08T23:01:34Z")

</div>

Hi! While my problem seems very trivial to solve, I still struggle coming up with a solution. I have a stream of data at a db called “products” with “autogen” retention policy (it has 2d lifespan and is gathering data …

---

## [Shift data by a calculated duration in a Tickscript](https://community.influxdata.com/t/shift-data-by-a-calculated-duration-in-a-tickscript/28893)

<div class="topic-metadata">

**Author:** [@joel73](https://community.influxdata.com/u/joel73)\
**Replies:** 1\
**Last updated:** [March 6, 2023, 4:48pm UTC](https://community.influxdata.com/t/shift-data-by-a-calculated-duration-in-a-tickscript/28893 "2023-03-06T16:48:24Z")

</div>

Hi, I am trying to set a timestamp in a stream to be written on a InfluxOutputNode. I read a stream, i read the timestamp from another stream, and i would like to use that timestamp to shift my starting datastream and…

---

## [Delivery of the data from the local influxdb to another influxdb in the cloud](https://community.influxdata.com/t/delivery-of-the-data-from-the-local-influxdb-to-another-influxdb-in-the-cloud/25807)

<div class="topic-metadata">

**Author:** [@andkuzmich](https://community.influxdata.com/u/andkuzmich)\
**Replies:** 0\
**Last updated:** [July 19, 2022, 12:09am UTC](https://community.influxdata.com/t/delivery-of-the-data-from-the-local-influxdb-to-another-influxdb-in-the-cloud/25807 "2022-07-19T00:09:31Z")

</div>

I try to collect some data from our remote measurement devices into influxdb in my private cloud. The locations where my devices are installed have very limited access to the Internet that is regularly interrupted. I put…

---

## [Count and calculate the duration of Boolean true](https://community.influxdata.com/t/count-and-calculate-the-duration-of-boolean-true/24698)

<div class="topic-metadata">

**Author:** [@muhammad\_shahzaib](https://community.influxdata.com/u/muhammad_shahzaib)\
**Replies:** 0\
**Last updated:** [April 20, 2022, 9:54am UTC](https://community.influxdata.com/t/count-and-calculate-the-duration-of-boolean-true/24698 "2022-04-20T09:54:15Z")

</div>

Can anybody guide me to write a tick script? I want to count the number of booleans true and write the result back to a new field. i want to calculate how many time acConnected was true. And also want to calculate durati…

---

## [Count and calculate the duration of Boolean true](https://community.influxdata.com/t/count-and-calculate-the-duration-of-boolean-true/24694)

<div class="topic-metadata">

**Author:** [@muhammad\_shahzaib](https://community.influxdata.com/u/muhammad_shahzaib)\
**Replies:** 0\
**Last updated:** [April 20, 2022, 8:05am UTC](https://community.influxdata.com/t/count-and-calculate-the-duration-of-boolean-true/24694 "2022-04-20T08:05:54Z")

</div>

can anybody guide me to write a tick script? I want to count the number of booleans true and write the result back to a new field. i want to calculate how many time acConnected was true. And also want to calculate durati…

---

## [Kapacitor: change synchronization time](https://community.influxdata.com/t/kapacitor-change-synchronization-time/24243)

<div class="topic-metadata">

**Author:** [@francescobianca](https://community.influxdata.com/u/francescobianca)\
**Replies:** 0\
**Last updated:** [March 15, 2022, 2:43pm UTC](https://community.influxdata.com/t/kapacitor-change-synchronization-time/24243 "2022-03-15T14:43:24Z")

</div>

Hi everyone I would like to trigger deadman alarms when I no longer receive measurements for a particular sensor. My code is as follows: var data = stream |from() .database(db) .retentionPolicy(rp) …

---

## [Memory leak due to join node](https://community.influxdata.com/t/memory-leak-due-to-join-node/20243)

<div class="topic-metadata">

**Author:** [@mrAbhishek](https://community.influxdata.com/u/mrAbhishek)\
**Replies:** 1\
**Last updated:** [June 8, 2021, 5:27am UTC](https://community.influxdata.com/t/memory-leak-due-to-join-node/20243 "2021-06-08T05:27:57Z")

</div>

Hello team, I am a running a tickscript by joining data from two measurments but one of the measurments has no data.When i disable the tickscript, the memory usage becomes stable but on enabling it, kapacitor docker( wh…

---

## [TICKscript to replace missing values with average of last 5 point](https://community.influxdata.com/t/tickscript-to-replace-missing-values-with-average-of-last-5-point/19323)

<div class="topic-metadata">

**Author:** [@levi](https://community.influxdata.com/u/levi)\
**Replies:** 1\
**Last updated:** [April 12, 2021, 8:04am UTC](https://community.influxdata.com/t/tickscript-to-replace-missing-values-with-average-of-last-5-point/19323 "2021-04-12T08:04:54Z")

</div>

Hi, I’m trying to write a TICKscript that replaces missing values with average of last 5 points and write the new data to a bucket. Here is my code: var currentDB = 'myDB' var currentRP = 'autogen' var measurement = …

---

## [Developing a measurement counter using batch queries](https://community.influxdata.com/t/developing-a-measurement-counter-using-batch-queries/18657)

<div class="topic-metadata">

**Author:** [@Benji\_Smith](https://community.influxdata.com/u/Benji_Smith)\
**Replies:** 5\
**Last updated:** [March 11, 2021, 6:26pm UTC](https://community.influxdata.com/t/developing-a-measurement-counter-using-batch-queries/18657 "2021-03-11T18:26:12Z")

</div>

Hello, I am a new user to Kapacitor, and I am trying to develop a counter for a measurement based off of the measurement incrementing over time. To do this, I decided to use batch queries. I made two queries for the sam…
