# Why query result cannot be generated all data (csv) of specific days in Elastic Search **URL:** \ **Category:** Kibana\ **Created:** [August 12, 2023, 6:14am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674 "2023-08-12T06:14:00Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![jt2023](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jt2023/32/123449_2.png) [@jt2023](https://discuss.elastic.co/u/jt2023)\ **Post date:** [August 12, 2023, 6:14am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674/1 "2023-08-12T06:14:01Z")
why query result cannot be generated all data (csv) of specific days in Elastic Search. For example, i searched for 15,16,17 July data, but only 17July can be generated and displayed in csv file ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [August 12, 2023, 7:11am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674/2 "2023-08-12T07:11:47Z")
Welcome! I have no idea about what you are talking about. Could you give more context? ---
**Author:** ![jt2023](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jt2023/32/123449_2.png) [@jt2023](https://discuss.elastic.co/u/jt2023)\ **Post date:** [August 12, 2023, 7:28am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674/3 "2023-08-12T07:28:02Z")
- I would like to generate query results of 15July , 16July and 17July . But after when viewing result in Elasticsearch, only 17 July can be viewed and the csv file generated are only 17 July also - How can the data of 3 days can be generated fully ? ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [August 12, 2023, 7:51am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674/4 "2023-08-12T07:51:46Z")
Please provide more context and details by answering the following questions: - Which version of Elasticsearch and Kibana are you using? - What is the size of the index/indices holding data for the requested time period? - What is the average size of your documents? - How many records do you get exported when you generate the CSV file? - How are you configuring/specifying the export? ---
**Author:** ![jt2023](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jt2023/32/123449_2.png) [@jt2023](https://discuss.elastic.co/u/jt2023)\ **Post date:** [August 12, 2023, 8:02am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674/5 "2023-08-12T08:02:39Z")
I am new to Elastic Search.. - Which version of Elasticsearch and Kibana are you using? I need to check - What is the size of the index/indices holding data for the requested time period? Please advise me where to check the size of the index - What is the average size of your documents? just data of 3 days - How many records do you get exported when you generate the CSV file?just data of 3 days - How are you configuring/specifying the export? Just go to Discover \> put the query in search bar with specific dates in dates filter and click "Share" with CSV file ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [August 12, 2023, 8:36am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674/6 "2023-08-12T08:36:34Z")
> [@jt2023](#): > > What is the size of the index/indices holding data for the requested time period? Please advise me where to check the size of the index Go into the Kibana console and query the [cat indices API](https://www.elastic.co/guide/en/elasticsearch/reference/8.8/cat-indices.html). > [@jt2023](#): > > What is the average size of your documents? just data of 3 days I asked about the average size of the JSON documents in the indices, not the period you are looking to extract. How many fields does each document on average have? What is the average size in bytes of the documents in JSON form? > [@jt2023](#): > > How many records do you get exported when you generate the CSV file?just data of 3 days What is the size of the file you managed to generate that only contained a subset of the data? How many records did you manage to get exported? ---
**Author:** ![jt2023](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jt2023/32/123449_2.png) [@jt2023](https://discuss.elastic.co/u/jt2023)\ **Post date:** [August 12, 2023, 8:46am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674/7 "2023-08-12T08:46:03Z")
Go to Kibana console and query the [cat indices API](https://www.elastic.co/guide/en/elasticsearch/reference/8.8/cat-indices.html) May you please advise me the way to do that ? Here is my contact +852 53743962 thanks ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [August 12, 2023, 8:53am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674/8 "2023-08-12T08:53:28Z")
Please have a look at [the Kibana docs](https://www.elastic.co/guide/en/kibana/8.9/console-kibana.html). ---
**Author:** ![jt2023](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jt2023/32/123449_2.png) [@jt2023](https://discuss.elastic.co/u/jt2023)\ **Post date:** [August 12, 2023, 9:05am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674/9 "2023-08-12T09:05:24Z")
this can only be searched in Kibana console ? ---
**Author:** ![jt2023](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jt2023/32/123449_2.png) [@jt2023](https://discuss.elastic.co/u/jt2023)\ **Post date:** [August 12, 2023, 9:14am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674/10 "2023-08-12T09:14:11Z")
About the size of the index \<\<\< this can only searched in Kibana console ? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 9, 2023, 9:15am UTC](https://discuss.elastic.co/t/why-query-result-cannot-be-generated-all-data-csv-of-specific-days-in-elastic-search/340674/11 "2023-09-09T09:15:03Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.