# Handling NAN and null values

**URL:** <https://community.grafana.com/t/handling-nan-and-null-values/60302>\
**Category:** Time Series Panel\
**Created:** [February 5, 2022, 9:04pm UTC](https://community.grafana.com/t/handling-nan-and-null-values/60302 "2022-02-05T21:04:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aramosvizcarra](https://avatars.discourse-cdn.com/v4/letter/a/ea666f/32.png) [@aramosvizcarra](https://community.grafana.com/u/aramosvizcarra)\
**Post date:** [February 5, 2022, 9:04pm UTC](https://community.grafana.com/t/handling-nan-and-null-values/60302/1 "2022-02-05T21:04:33Z")

</div>

In this [URL](https://grafana.com/docs/grafana/latest/panels/expressions/#reduce) there is a note about including functions to control NaN, null and empty values. Is there an estimated time when this would happen and is the plan to create functions to allow filtering those values in the query?

Thanks in advance,

---

<div class="post-metadata">

**Author:** ![anon70503803](https://avatars.discourse-cdn.com/v4/letter/a/8797f3/32.png) [@anon70503803](https://community.grafana.com/u/anon70503803)\
**Post date:** [February 11, 2022, 9:34pm UTC](https://community.grafana.com/t/handling-nan-and-null-values/60302/2 "2022-02-11T21:34:52Z")

</div>

welcome to the :grafana: forum, @aramosvizcarra

I don’t know about the state of expressions, but you should explore transformations. There are some that deal with special values like `NaN` that might be useful:

> **[Transform data | Grafana documentation](https://grafana.com/docs/grafana/latest/panels-visualizations/query-transform-data/transform-data/)**
>
> Transform data Transformations are a powerful way to manipulate data returned by a query before the system applies a visualization. Using transformations, you can:
> Rename fields Join time series data Perform mathematical operations across queries Use...