# Getting spike, when expecting 0

**URL:** <https://forum.inductiveautomation.com/t/getting-spike-when-expecting-0/37943>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [August 20, 2020, 1:34pm UTC](https://forum.inductiveautomation.com/t/getting-spike-when-expecting-0/37943 "2020-08-20T13:34:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vipo](https://avatars.discourse-cdn.com/v4/letter/v/eada6e/32.png) [@vipo](https://forum.inductiveautomation.com/u/vipo)\
**Post date:** [August 20, 2020, 1:34pm UTC](https://forum.inductiveautomation.com/t/getting-spike-when-expecting-0/37943/1 "2020-08-20T13:34:33Z")

</div>

When I pull a tag history with Aggregation Mode on RANGE and set the Query Mode to PERIODIC with 2 minute interval ( or less ) I get these spikes. As I understand it, it should be 0 in this interval, since the data has not changed.

If I change the interval to 10 minutes, I get the expected results, without any spikes.

I’m I missing the obvious ?

please help.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/e/6e9e9b39709ff1e3e2f60e69b3930e5d0db12d2d.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/3/f3aa8049a2a335f2c84d5512940522b7ca592f3a.png)

---

<div class="post-metadata">

**Author:** ![wking](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wking/32/21823_2.png) [@wking](https://forum.inductiveautomation.com/u/wking)\
**Post date:** [August 20, 2020, 1:45pm UTC](https://forum.inductiveautomation.com/t/getting-spike-when-expecting-0/37943/2 "2020-08-20T13:45:15Z")

</div>

I think you want variance?

---

<div class="post-metadata">

**Author:** ![vipo](https://avatars.discourse-cdn.com/v4/letter/v/eada6e/32.png) [@vipo](https://forum.inductiveautomation.com/u/vipo)\
**Post date:** [August 20, 2020, 2:05pm UTC](https://forum.inductiveautomation.com/t/getting-spike-when-expecting-0/37943/3 "2020-08-20T14:05:19Z")

</div>

Variance produces floating point numbers - that is not what I want.  
This is from the documentation for Range:  
**Range** - Returns the range between the highest and lowest value for the period.

And since the Highest and the Lowest are the same number, it should give 0, and not 664.

---

<div class="post-metadata">

**Author:** ![vipo](https://avatars.discourse-cdn.com/v4/letter/v/eada6e/32.png) [@vipo](https://forum.inductiveautomation.com/u/vipo)\
**Post date:** [August 20, 2020, 2:20pm UTC](https://forum.inductiveautomation.com/t/getting-spike-when-expecting-0/37943/4 "2020-08-20T14:20:59Z")

</div>

Ok - I figured out how to fix it when I use Direct Tag.  
If I turn on the “Prevent Interpolation” it gives me the correct value ( 0 )

However, I’m using an expression to receive the tag list.  
Does anyone know how to “Prevent Interpolation” while using an expression ?  
It does not seem to trigger when I select it.