# Changing @timestamp makes data unqueryable on grafana

**URL:** <https://discuss.elastic.co/t/changing-timestamp-makes-data-unqueryable-on-grafana/89074>\
**Category:** Logstash\
**Created:** [June 12, 2017, 3:38pm UTC](https://discuss.elastic.co/t/changing-timestamp-makes-data-unqueryable-on-grafana/89074 "2017-06-12T15:38:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gfitzy123](https://avatars.discourse-cdn.com/v4/letter/g/258eb7/32.png) [@gfitzy123](https://discuss.elastic.co/u/gfitzy123)\
**Post date:** [June 12, 2017, 3:38pm UTC](https://discuss.elastic.co/t/changing-timestamp-makes-data-unqueryable-on-grafana/89074/1 "2017-06-12T15:38:10Z")

</div>

Hi there. Heres the conf file.

input {  
file {  
path =\> [  
"/Users/garrett/Desktop/failures-march-legacy.csv",  
"/Users/garrett/Desktop/failures-march-cms.csv"  
]

```
   start_position => "beginning"
   type => "changes"
   sincedb_path => "/dev/null"

```

}  
}

filter {

```
csv {
  columns => [
      "SR #",
      "Customer",
      "Change Owner",
      "Cross Tower Review",
      "Cross Tower Reviewer",
      "Cross Tower Reviewer Status",
      "Senior Manager",
      "Squad Leader Approval - Hypercare",
      "Summary",
      "Data Center",
      "Logical or Physical?",
      "Severity",
      "Scheduled_Start",
      "Scheduled Finish",
      "Environment",
      "Change Type",
      "Service Line",
      "Reason for Failure",
      "Code",
      "Caused SEV1?"
      ]
}

date {
  match => ["Scheduled_Start", "M/dd/yyyy HH:mm:ss", "M/dd/yyyy HH:mm", "ISO8601"]
  target => "@timestamp"
}

```

}

output {  
elasticsearch {  
hosts =\> ["localhost:9200"]  
index =\> "test"  
}  
stdout { codec =\> rubydebug }  
}

@timestamp is changed correctly. The data is correctly uploaded to elastic, verified by a get request. But when I try to create a new dashboard, it seems that the data cannot be queried by grafana to create a new visualization.

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [June 12, 2017, 4:02pm UTC](https://discuss.elastic.co/t/changing-timestamp-makes-data-unqueryable-on-grafana/89074/2 "2017-06-12T16:02:03Z")

</div>

> But when I try to create a new dashboard, it seems that the data cannot be queried by grafana to create a new visualization.

Could you be a bit more specific? Do you get any error message, for example?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 10, 2017, 4:02pm UTC](https://discuss.elastic.co/t/changing-timestamp-makes-data-unqueryable-on-grafana/89074/3 "2017-07-10T16:02:10Z")

</div>

Closed on July 10, 2017, 4:02pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.