# Export CSV or table contins \*\*Split metrics by \*\* in table does not exports correctly

**URL:** <https://discuss.elastic.co/t/export-csv-or-table-contins-split-metrics-by-in-table-does-not-exports-correctly/361860>\
**Category:** Kibana\
**Tags:** lens, dashboard\
**Created:** [June 21, 2024, 6:44pm UTC](https://discuss.elastic.co/t/export-csv-or-table-contins-split-metrics-by-in-table-does-not-exports-correctly/361860 "2024-06-21T18:44:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kishorkumar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kishorkumar/32/132930_2.png) [@kishorkumar](https://discuss.elastic.co/u/kishorkumar)\
**Post date:** [June 21, 2024, 6:44pm UTC](https://discuss.elastic.co/t/export-csv-or-table-contins-split-metrics-by-in-table-does-not-exports-correctly/361860/1 "2024-06-21T18:44:22Z")

</div>

This report table is created using lens and have used the **Split metrics** by to show it per day in columns  
my report on looks like this in lens.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/9/19908d37ebac1fc146f964275cc1b3374acee16e.png)

but when i download as csv then its messed up

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/6/7603efb77cea9e4bb1364522cecabb2a6bd53252.png)

you can all the per day dates are just moved to the left one column.

#kibana #lens #elasticsearch

---

<div class="post-metadata">

**Author:** ![Teresa\_Alvarez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/teresa_alvarez/32/102490_2.png) [@Teresa\_Alvarez](https://discuss.elastic.co/u/Teresa_Alvarez)\
**Post date:** [September 20, 2024, 12:19pm UTC](https://discuss.elastic.co/t/export-csv-or-table-contins-split-metrics-by-in-table-does-not-exports-correctly/361860/2 "2024-09-20T12:19:46Z")

</div>

Sorry for the late reply @kishorkumar we are working on a fix right now and it should be available soon [[Lens] Fix issue downloading tables to CSV that contain "Split metrics by" · Issue #187551 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/187551)
