I’m having trouble visualising my data in a time series chart. I have my sales data in my source sheet. And I’m trying to visualise sales per month . As you can see, I’ve applied a control at the top for the SKU and the time period. I’ve also changed the You can also see the total quantity of that SKU sold in the time period. However, no data shows in the chart! Any clues as to what I’m doing wrong here would be appreciated!
Silly questions maybe, but can’t tell without asking:
- Is the date control filtering the entire report or just the time series chart?
- If just the time series, are you certain there’s data within that timeframe that’s selected for that SKU?
- Just curious…do you see the same behavior with different chart types (e.g. a regular line chart)?
Sometimes it’s helpful for me to just display the data in an unfiltered Table chart that kind of matches my data source schema and filter things down one at a time.
Not a silly question! I thought mine was to begin with lol!
- Is the date control filtering the entire report or just the time series chart? - just for the chart
- If just the time series, are you certain there’s data within that timeframe that’s selected for that SKU? yes, there is data available, thats why I put in the scorecard also at the bottom, as a sort of check
- Just curious…do you see the same behavior with different chart types (e.g. a regular line chart)? - tried a line chart after you asked, and it seems to work, although it doesnt give an even representation of the data (see screenshot below)
Filtering on a time series chart can be tricky, especially if the data isn’t continuous over your time period. For simple measurements of some metric over time, I generally default to a Line chart. If using a Time Series chart is required, you can try playing with the “Missing Data” settings under the “STYLE” menu.
I thought sales vs time was a pretty simple place to start! 
Will check on the missing data setting and let you know if that works, but from what I recall it did not change anything on the chart when i was experimenting with settings earlier.
Tried messing with the “Missing data” settings to no avail. Looks like time charts are a no go!
I’m sorry you’re having trouble with the time series viz and I’m honestly not sure what the issue might be. I mocked up a simple dataset with just a date and a metric (using sum as the metric aggregate function) and the data in the time series chart is showing up just fine. I tried both adding a filter to the viz directly and adding a control to the report. No issues.
If you still need help here and if you’re comfortable sharing a non-sensitive sample of your dataset (or even a public copy of the report), I can try to recreate the viz on my end.
Thank you. I think the issue lies with the complexity of the data source. I stripped the data down to the bare necessary columns and it seems to work now. I’ll try adding data back, one column at a time, and see where it breaks.
Is there a limit on the amount of data that can be housed in a data source? My data is in google sheets, and I’m on a Pro plan.
Good to hear that you’re able to start narrowing down the root cause. As for the size limit, there’s no size limit on the Looker Studio (Pro) side per se, but the size restriction is instead on the Google Sheet/Google Drive side.
Spreadsheets
- Up to 10 million cells or 18,278 columns (column ZZZ) for spreadsheets that are created in or converted to Google Sheets.
- Up to 10 million cells or 18,278 columns for spreadsheets imported from Microsoft Excel. The limits are the same for Excel and CSV imports.
- When you convert a document from Excel to Google Sheets, any cell with more than 50,000 characters will be removed in Sheets.
- Up to 100k rows for pivot tables in Connected Sheets.
- Up to 500k rows or 5m cells for extracts in Connected Sheets.