Request: Multiple Y-Axis data sources in Charts

[Brian_Gumm2]

I believe this will be a fairly common request and it’s something I noticed right off the bat when designing a dashboard interface for one of my “aggregation tables” for an e-commerce store that’s being fed data from Shopify.

Use Case: New Customers vs. Churned Customers in a given Cohort Year
Currently, it seems I have to create two separate charts, like so…

Ideally, I would like to lay these two charts “on top of each other.” They’re both drawing data from the same table, so the X-Axis is the same. The Y-Axis is just 2 different columns’ values in the same table & rows.

[Tristan-ARG]

I am also needing this!

+1

[shemeka]

+1 for this!

[Jason_Rosoff]

Another vote for this feature. It is stopping me from using interfaces to solve my reporting problems.

[David_O_Leary]

Adding my name to the mix here. Echoing all the previous comments. This is really basic (and valuable) functionality that makes me reconsider even using AirTable. Dashboards was one of the features that sold me on AT initially. But this limitation is making me reconsider. 

[laurenb]

Really need this!

[Markus_]

+1 multiple Ys would mean so much!

[laurenb]

While we await the aggregation feature, I wanted to share my workaround. I created a separate table linked to the primary data source, containing a record for each X/Y axis combination with a summary column.

[JeremyK]

I really want this solution as well.

Whats confusing about this is that in their releases, Airtable claims to have released features for this but I'm not seeing them. Look at "Multiple series and dual y-axes in charts" in July 2024. Maybe it needs to be under a newer interface page type but I'm not able to take a standard chart and do this.

https://www.airtable.com/whatsnew

EDIT: I figured it out! You have to select "Dashboard" type when generating a new page. It works!

[Shaun_Parfett_S]

Thanks for sharing! Much appreciated,

[kblaine]

Thanks for this. SUPER helpful. Was trying to get this feature in the "Blank" slate interface. Using "Dashboard" as a template makes this a lot easier.