[Lens] Not having feature to set last bucket value

[harnish-elastic]

Kibana version: 8.6.0

Elasticsearch version: 8.6.0

Describe the bug:

While migrating visualizations to lens, found that Lens doesn't have a support for last bucket value. Due to this thing, not able to migrate visualization to lens because the count getting mismatched due to the last bucket value is showing the value of last bucket while the lens is working on entire time range. Hence not able to migrate these kind of visualizations to lens. Please refer the below screenshot.

[elasticmachine]

Pinging @elastic/kibana-visualizations @elastic/kibana-visualizations-external (Team:Visualizations)

[stratoula]

@harnish-elastic have you tried to use the reduced time range to simulate the last bucket behavior?

[harnish-elastic]

@harnish-elastic have you tried to use the reduced time range to simulate the last bucket behavior?

@stratoula Yes, we have tried using the reduced time range to simulate the last bucket behavior. However we are not able to match the value of the particular metrics in same time range. Please refer the screenshots for further process. Let me know if I have missed something or you need anything else. Thanks!

Lens:

TSVB:

[stratoula]

@harnish-elastic if you go to your TSVB chart and switch to timeseries which bucket size is used? You can find it from the x-axis label.

[harnish-elastic]

@harnish-elastic if you go to your TSVB chart and switch to timeseries which bucket size is used? You can find it from the x-axis label.

Thank you for providing screenshot. I have checked the bucket size. It is showing 5 minutes. However I am still not able to match the counts in lens. Please refer the below screenshot. Let me know is there anything else I need to correct.

TSVB:

Lens:

[stratoula]

@harnish-elastic thanx! Can you ping me in Slack to investigate together?

[stratoula]

So the problem here is that in TSVB the last bucket is dropped while in Lens is kept
@harnish-elastic will check why they are dropping the last bucket. If it is needed we need to support it in Lens, otherwise you can transform this to Lens without dropping the last bucket (which can be confusing and in general we dont recommend it)

[harnish-elastic]

@stratoula We haven't requirement for dropped last bucket option. But we strongly have requirements of reduced timerange value option to set to auto in lens charts . The reason behind this requirement is every time user won't go to update the reduced timerange value while filtering out the time. Kibana currently supporting only this values for reduced timerange option.

[stratoula]

Great, yes I have it on my list to discuss it with the team but I agree that is a nice addition to Lens!

[harnish-elastic]

As discussed with the team, the TSVB visualizations which contains the last bucket can be converted to lens line charts which is the best solution. Hence closing this issue.