# Transform data with false time range

**URL:** <https://discuss.elastic.co/t/transform-data-with-false-time-range/244015>\
**Category:** Elasticsearch\
**Tags:** transforms\
**Created:** [August 6, 2020, 11:49am UTC](https://discuss.elastic.co/t/transform-data-with-false-time-range/244015 "2020-08-06T11:49:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![marcospi](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@marcospi](https://discuss.elastic.co/u/marcospi)\
**Post date:** [August 6, 2020, 11:49am UTC](https://discuss.elastic.co/t/transform-data-with-false-time-range/244015/1 "2020-08-06T11:49:48Z")

</div>

Hey there,

I want to use the transform method to transform my original data in a more compact version. In my orignal data I have at aech document the fields "unique user Id" and the exact date.

Now I want to transform this data to a more compact version with the number of unique users grouped by day. So after the transformation I get the following results

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

The problem is now that I get the number of users for the time range from 2 am to 2 am of the next day. I think this depends on the default timezone of elasticsearch. I also tried to add some parameters like "offset" or "time\_zone" but this doesn't work for the transform feature.

Is there any workaround for this issue?

---

<div class="post-metadata">

**Author:** ![Hendrik\_Muhs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hendrik_muhs/32/25802_2.png) [@Hendrik\_Muhs](https://discuss.elastic.co/u/Hendrik_Muhs)\
**Post date:** [August 6, 2020, 2:22pm UTC](https://discuss.elastic.co/t/transform-data-with-false-time-range/244015/2 "2020-08-06T14:22:20Z")

</div>

Time zone and offset are currently not supported in transform.

If you are not using a continuous transform you could use [script](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-datehistogram-aggregation.html#_scripts_2) to implement time zone offsetting yourself.

Feel free to open an enhancement request in github.

---

<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:** [September 3, 2020, 2:22pm UTC](https://discuss.elastic.co/t/transform-data-with-false-time-range/244015/3 "2020-09-03T14:22:22Z")

</div>

Closed on September 3, 2020, 2:22pm UTC

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