Kibana transform latest continously not updating

[charles97 (Charles)]

Hi everyone, so I'm trying on the latest transform.
I have 3 files. Those are: name, status, tgl.

1. I will ingest data1 and data2 at the same time to index transformtest
2. then I will create transformation index transformtest_continuous.
3. Then I will ingest data3.

data1

name,status,tgl
a,0,3/5/2018 1:21:31 AM
b,0,3/5/2018 1:21:31 AM
c,0,3/5/2018 1:21:31 AM

data2

name,status,tgl
a,0,3/5/2019 1:21:31 AM
b,1,3/5/2019 1:21:31 AM
c,1,3/5/2019 1:21:31 AM

data3

name,status,tgl
a,0,3/5/2020 1:21:31 AM
b,4,3/5/2020 1:21:31 AM
c,4,3/5/2020 1:21:31 AM

1. transformtest index containing 6 rows of data

a,0,3/5/2018 1:21:31 AM
b,0,3/5/2018 1:21:31 AM
c,0,3/5/2018 1:21:31 AM
a,0,3/5/2019 1:21:31 AM
b,1,3/5/2019 1:21:31 AM
c,1,3/5/2019 1:21:31 AM

2. transformtest_continuous created with name as Unique keys and tgl as sort field. index containing 3 data

a,0,3/5/2019 1:21:31 AM
b,1,3/5/2019 1:21:31 AM
c,1,3/5/2019 1:21:31 AM

3. Data3 ingest, transformtest updated, now they have 9 rows

a,0,3/5/2018 1:21:31 AM
b,0,3/5/2018 1:21:31 AM
c,0,3/5/2018 1:21:31 AM
a,0,3/5/2019 1:21:31 AM
b,1,3/5/2019 1:21:31 AM
c,1,3/5/2019 1:21:31 AM
a,0,3/5/2020 1:21:31 AM
b,4,3/5/2020 1:21:31 AM
c,4,3/5/2020 1:21:31 AM

but transform_continuous not updated. I expected it would be data3

a,0,3/5/2020 1:21:31 AM
b,4,3/5/2020 1:21:31 AM
c,4,3/5/2020 1:21:31 AM

Am I missing something?

[Hendrik_Muhs]

Can you share your configuration?

What did you configure for sync? From the data provided it looks like you are ingesting data with old timestamps, however the timestamp in sync should be recent to be seen.

[charles97 (Charles)]

After some try-ons I realize that i have to bind the timeseries with timestamp not time columns (tgl). after change the time sync, it works properly. Thank you @Hendrik_Muhs for your respond. appreciate that so much. I don't understand why it sync properly with timestamp but not tgl