Help

X-axis as continuous dates?

2624 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Alberto_Mannil
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone, new here.
Im trying to graph continuous dates on the graph block. Airtable only uses the dates on the record and skips any dates for which there were no records created.It’s very easy to do in Excel, but am unsure if Airtable Can do it. Help?

6 Replies 6
Mike_McLaughlin
8 - Airtable Astronomer
8 - Airtable Astronomer

I think here, see red circle:

image

Alberto_Mannil
5 - Automation Enthusiast
5 - Automation Enthusiast

Airtable
Excel

Alberto_Mannil
5 - Automation Enthusiast
5 - Automation Enthusiast

I think Empty Cells is only on existing records.
I would need to add empty records on every day where there wasn’t a record entry.
Airtable

Russell_Bishop1
8 - Airtable Astronomer
8 - Airtable Astronomer

I also really need this update – Charts are misleading when the X axis is a date, but can jump between dates when there’s no data. It’s empty, but it should display!

Russell_Bishop1
8 - Airtable Astronomer
8 - Airtable Astronomer

Oddly - Line mode does work in the expected way.

William_Trevill
4 - Data Explorer
4 - Data Explorer

I agree. This is an issue. Please fix!