Timeline chart only showing certain number of rows from googlesheet data source

[Davidh73]

Hi All, 
I have a timeline chart in looker studio which has a csv data source set with columns

start_time

end_time

short_description

known_impact

type

geo

notes

The timeline chart is only displaying 23 rows of this data when there are 45 rows in the googlesheet.

All the columns are formatted as plain text other than the date time which are formatted date time e.g. 29/08/2024 00:00:00

I have tried:

reconnecting the data source
removing the data source and readding
renaming the data source and readding, reconnecting
deleting the chart and recreating the chart

none of these has solved the issue.
Any other ideas to resolve would be much appreciated.

[LauraStone]

Also having an issue with the timeline seemingly filtering data rows. Did you find a solution to this?

[Davidh73]

I have not been able to show all rows yet in the chart. 90 rows in the data_source, but only c. 30 show in the actual dashboard timeline chart.

- The chart currently has 2500 selected in set up total records.
- Toggling this setting between 5 -50 works for minimising the rows
- Setting it greater than 100 (100....250, 500, 1000, etc.) does not show the extra rows.

The issue appears to be with this setting.

In terms of showing the data again if it disappears. Eventually renaming and reconnected worked, as well as changing the format of the chart in set up (I added a short_desc name of the data point to bar label).