# Can we remove the date column from our reports?

**URL:** <https://discuss.elastic.co/t/can-we-remove-the-date-column-from-our-reports/344072>\
**Category:** Kibana\
**Tags:** elastic-stack-reporting\
**Created:** [September 28, 2023, 1:58pm UTC](https://discuss.elastic.co/t/can-we-remove-the-date-column-from-our-reports/344072 "2023-09-28T13:58:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mpjjonker](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mpjjonker/32/95796_2.png) [@mpjjonker](https://discuss.elastic.co/u/mpjjonker)\
**Post date:** [September 28, 2023, 1:58pm UTC](https://discuss.elastic.co/t/can-we-remove-the-date-column-from-our-reports/344072/1 "2023-09-28T13:58:34Z")

</div>

I have seen topics about removing the date (time) column from the discover tableview and I understand it is not that easy.  
But maybe there is an easy way to prevent this column from being included in the CSV reports ?

---

<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:** [October 25, 2023, 3:03pm UTC](https://discuss.elastic.co/t/can-we-remove-the-date-column-from-our-reports/344072/2 "2023-10-25T15:03:23Z")

</div>

Not from the UI but if you copy the POST request from the CSV advanced options you can remove the date field from the `columns` key

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

My steps where:

- Copy that POST URL to a text editor
- Copy the `jobParams` parameter value into an [HTML character decoder](https://meyerweb.com/eric/tools/dencoder/) to easily detect the `order_date` (my date field) from the `columns` key and remove it.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/1/c18a4348e4d482324e57c3625444742920b40ed6.png)
- Encode again the string
- Put that back to a `curl` POST request and call that endpoint

```auto
curl -s -u "${ELASTIC_USER}:${ELASTIC_PASSWORD}" \
  -X POST -H 'kbn-xsrf: true' -H 'Content-Type: application/json' \
  "${KIBANA_HOST}/api/reporting/generate/csv_searchsource?jobParams=(browserTimezone%3AEurope%2FMadrid%2Ccolumns%3A!(products.product_name%2Cproducts.price%2Cproducts.manufacturer%2Ccustomer_full_name)%2CobjectType%3Asearch%2CsearchSource%3A(fields%3A!((field%3Aorder_date%2Cinclude_unmapped%3Atrue)%2C(field%3Aproducts.product_name%2Cinclude_unmapped%3Atrue)%2C(field%3Aproducts.price%2Cinclude_unmapped%3Atrue)%2C(field%3Aproducts.manufacturer%2Cinclude_unmapped%3Atrue)%2C(field%3Acustomer_full_name%2Cinclude_unmapped%3Atrue))%2Cfilter%3A!((meta%3A(field%3Aorder_date%2Cindex%3Aff959d40-b880-11e8-a6d9-e546fe2bba5f%2Cparams%3A())%2Cquery%3A(range%3A(order_date%3A(format%3Astrict_date_optional_time%2Cgte%3A%272023-09-07T00%3A04%3A19.000Z%27%2Clte%3A%272023-10-07T23%3A45%3A36.000Z%27)))))%2Cindex%3Aff959d40-b880-11e8-a6d9-e546fe2bba5f%2Cquery%3A(language%3Akuery%2Cquery%3A%27%27)%2Csort%3A!((order_date%3Adesc)))%2Ctitle%3A%27eCommerce%20data%27%2Cversion%3A%278.10.3%27)"

```

- Get the CSV from the Kibana Reporting UI and confirm the `order_date` was not included.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/3/53f65d58ec8fbc1d6cbf957e57a7425ca98e9fb0.png)

Hope it helps.

---

<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:** [November 22, 2023, 3:03pm UTC](https://discuss.elastic.co/t/can-we-remove-the-date-column-from-our-reports/344072/3 "2023-11-22T15:03:50Z")

</div>

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