Wide vs narrow bars in lens

[gservat]

Kibana version: 7.8.0

Description of the problem including expected versus actual behavior:

I built a couple of visualizations using Lens and they both have the same interval and time range, however one has really wide bars and the other narrow ones:

Any ideas why that is?

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[wylieconlon]

@gservat I have a few theories about why, but it would help to collect more information:

• Is this an auto interval, or is there a minimum interval that you chose?
• How does the same chart look in Visualize?
• Can you show a screenshot or describe the full chart configuration in Lens?
• If you can show a datatable equivalent of the same chart it would help us to reproduce the situation

[gservat]

Hi @wylieconlon thanks for taking a look at this.

Is this an auto interval, or is there a minimum interval that you chose?

I haven't customized the time interval, so yeah, auto.

How does the same chart look in Visualize?

Exactly the same as in the dashboard:

Can you show a screenshot or describe the full chart configuration in Lens?

It's a stacked bar chart with @timestamp on the X-axis, Count of records on the Y-axis and broken down by a keyword field. Let me know if there's anything I've missed here that you're interested in.

If you can show a datatable equivalent of the same chart it would help us to reproduce the situation

This is the data table from the one showing narrow columns:

This is from the wide columns:

[flash1293]

How does the same chart look in Visualize?

@gservat I think what @wylieconlon meant here is how the chart looks like if the configuration is re-created using the "Vertical Bar" visualization type from the new visualization dialog:

• Go to "Visualize" from the side bar
• Click "Create visualization"
• Select "Vertical Bar"

Another possible cause: Is one of these charts built using a rollup index pattern?

[gservat]

Apologies for the slow response. These charts are based on filebeat data (no rollups).

Seems to look fine in vertical bar:

Lens

Vertical Bar

[flash1293]

Thanks @gservat

To me this looks like a problem with the auto-width detection of elastic-charts. If there are multiple values in the time series we are leaving it up to the chart to figure out the width of the column, but completely empty rows are filtered out. If there are empty rows after the first row containing a value, all empty buckets after it will be added to the width of the bars.

Since we but this logic into place we got a new way of determining the interval of a date dimension - data.search.aggs.getDateMetaByDatatableColumn.

I can put up a PR for this.