# Chronograf return different result then influx cli

**URL:** <https://community.influxdata.com/t/chronograf-return-different-result-then-influx-cli/1563>\
**Category:** Dashboards\
**Tags:** influxdb, chronograf\
**Created:** [July 10, 2017, 6:12am UTC](https://community.influxdata.com/t/chronograf-return-different-result-then-influx-cli/1563 "2017-07-10T06:12:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![miki\_haiat](https://avatars.discourse-cdn.com/v4/letter/m/e47774/32.png) [@miki\_haiat](https://community.influxdata.com/u/miki_haiat)\
**Post date:** [July 10, 2017, 6:12am UTC](https://community.influxdata.com/t/chronograf-return-different-result-then-influx-cli/1563/1 "2017-07-10T06:12:01Z")

</div>

im having a weird issue with chronograf

for the same query im receiving a different result …

on the cli **count\_status 1897**

> SELECT count(“status”) AS “count\_status” FROM “telegraf”.“autogen”.“parking” WHERE time \> now() - 7d AND \>“status”=‘vacant’
> 
> > name: parking  
> > time count\_status
> 
> * * *
> 
> 1499061336943289401 1897

on the chronograf **count\_status 1**

---

<div class="post-metadata">

**Author:** ![jackzampolin](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/jackzampolin/32/5_2.png) [@jackzampolin](https://community.influxdata.com/u/jackzampolin)\
**Post date:** [July 10, 2017, 6:11pm UTC](https://community.influxdata.com/t/chronograf-return-different-result-then-influx-cli/1563/2 "2017-07-10T18:11:13Z")

</div>

@miki_haiat Can you share the exact query you are running in Chronograf?

---

<div class="post-metadata">

**Author:** ![miki\_haiat](https://avatars.discourse-cdn.com/v4/letter/m/e47774/32.png) [@miki\_haiat](https://community.influxdata.com/u/miki_haiat)\
**Post date:** [July 11, 2017, 6:16am UTC](https://community.influxdata.com/t/chronograf-return-different-result-then-influx-cli/1563/3 "2017-07-11T06:16:49Z")

</div>

> [@miki\_haiat](#):
>
> SELECT count(“status”) AS “count\_status” FROM “telegraf”.“autogen”.“parking” WHERE time \> now() - 7d AND \>“status”=‘vacant’

Hi @jackzampolin  
I tried again this morning

on cli

> SELECT count(“status”) AS “count\_status” FROM “telegraf”.“autogen”.“parking” WHERE time \> now() - 7d AND “status”=‘vacant’  
> name: parking  
> time count\_status
> 
> * * *
> 
> 1499148790334962201 1897

on chronograf no results
