# Influx DB : Flux grouping problem

**URL:** <https://community.influxdata.com/t/influx-db-flux-grouping-problem/29713>\
**Category:** InfluxDB 2\
**Tags:** flux\
**Created:** [April 28, 2023, 7:10am UTC](https://community.influxdata.com/t/influx-db-flux-grouping-problem/29713 "2023-04-28T07:10:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Diptarko](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/diptarko/32/13324_2.png) [@Diptarko](https://community.influxdata.com/u/Diptarko)\
**Post date:** [April 28, 2023, 7:10am UTC](https://community.influxdata.com/t/influx-db-flux-grouping-problem/29713/1 "2023-04-28T07:10:52Z")

</div>

Hello,  
Stuck on this problem. I am trying to group my data based on my tag .  
My Flux query is as follows :-  
from(bucket: “”)  
|\> range(start: -2d)  
|\> filter(fn: (r)=\>r.\_measurement==“agrovet-sensors”)  
|\> group(columns:[“”])

 ![Error Message](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/9/9d094772a54e5a129e3d36d610a60bd6a3a8d0d1.png)

I get an error message as follows:  
schema collision: cannot group float and integer types together.  
Stuck at this point and need help. Thanks in advance

---

<div class="post-metadata">

**Author:** ![Anaisdg](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/anaisdg/32/6401_2.png) [@Anaisdg](https://community.influxdata.com/u/Anaisdg)\
**Post date:** [May 3, 2023, 3:42pm UTC](https://community.influxdata.com/t/influx-db-flux-grouping-problem/29713/2 "2023-05-03T15:42:12Z")

</div>

Hello @Diptarko,  
Can you please try converting your float to int or int to float first?  
You can use any of the following:  
Great if you need to convert a column other than \_value:

> **[float() function | Flux 0.x Documentation](https://docs.influxdata.com/flux/v0.x/stdlib/universe/float/)**
>
> float() converts a value to a float type.

> **[int() function | Flux 0.x Documentation](https://docs.influxdata.com/flux/v0.x/stdlib/universe/int/)**
>
> int() converts a value to an integer type.

example:

```auto
data
    |> map(fn: (r) => ({r with exampleCol: float(v: r.exampleCol)}))

```

These for converting \_value column

> **[toInt() function | Flux 0.x Documentation](https://docs.influxdata.com/flux/v0.x/stdlib/universe/toint/)**
>
> toInt() converts all values in the \_value column to integer types.

> **[toFloat() function | Flux 0.x Documentation](https://docs.influxdata.com/flux/v0.x/stdlib/universe/tofloat/)**
>
> toFloat() converts all values in the \_value column to float types.

example

```auto
import "sampledata"

sampledata.int()
    |> toFloat()

```

Hope that helps!