Here is a summary of the text in 1 paragraph: In this post, InfluxDB and TICK-stack related issues are discussed, including comparing data with Kapacitor. The issue of identical tag keys and field keys causing query confusion when trying to specify tags in the WHERE clause is addressed, and a solution using the `::tag` syntax is provided. Additionally, using Kapacitor to compare data from previous weeks to current weeks is explained, with a solution involving shifting the data to match timestamps using the `shift` function. Finally, casting functionality is discussed, with an example of how to cast floats to integers using InfluxQL's `<field_key>::<type>` syntax.