# Revit Event / Timestamp field problem

**URL:** <https://discuss.elastic.co/t/revit-event-timestamp-field-problem/300341>\
**Category:** Kibana\
**Tags:** elastic-stack-monitoring\
**Created:** [March 22, 2022, 1:20pm UTC](https://discuss.elastic.co/t/revit-event-timestamp-field-problem/300341 "2022-03-22T13:20:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bailarch](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bailarch/32/92546_2.png) [@bailarch](https://discuss.elastic.co/u/bailarch)\
**Post date:** [March 22, 2022, 1:20pm UTC](https://discuss.elastic.co/t/revit-event-timestamp-field-problem/300341/1 "2022-03-22T13:20:27Z")

</div>

Hello,

Not sure if anyone is familiar with Revit but I have a problem with '@timestamp' field from Revit Event.

Basically I want to see all the projects that have been opened during past 7 days and I did set my Dev tool code to 24hr range so the result will not have any duplicate project on each day (24hr).

However, when bringing that information into Power BI, it is still recording every microsecond of the project activity therefore it is impossible for me to go beyond more than 12hrs with 10,000 max data limit.

![image](https://us1.discourse-cdn.com/elastic/original/3X/b/f/bf4d5f07aceecda637d4d70b44face5a6d41aada.png)

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/a/2ad4230b48b0724f143e4c5364d094784d2b40f8.png)

I tried Scroll to get the entire list of the project but the problem is that I want to use auto-refresh function from Elastic cloud but Scroll isn't allowed.

Please let me know if you have any further question.

Best,  
KP

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [March 23, 2022, 3:57pm UTC](https://discuss.elastic.co/t/revit-event-timestamp-field-problem/300341/2 "2022-03-23T15:57:15Z")

</div>

It's not totally clear to me how you are running your queries but I tried to reproduce a similar query using the `kibana_sample_data_flights` last year of data rounded to the week, aggregating records with a date histogram per week, and with a filter (`Cancelled: true`) and my query looks like this:

```auto
GET kibana_sample_data_flights/_search
{
  "size": 0, 
  "aggs": {
    "cancelled_flights_histogram": {
      "date_histogram": {
        "field": "timestamp",
        "calendar_interval": "1w"
      }
    }
  },
  "query": {
    "bool": {
      "filter": [
        {
          "match_phrase": { "Cancelled": true }
        },
        {
          "range": {
            "timestamp": { "gte": "now-1y/w" }
          }
        }
      ]
    }
  }
}

```

Maybe the issue is on using the `fixed_interval` or how you set up the `gte` filter?

---

<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:** [April 20, 2022, 3:57pm UTC](https://discuss.elastic.co/t/revit-event-timestamp-field-problem/300341/3 "2022-04-20T15:57:28Z")

</div>

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