Help

Re: Request: Multiple Y-Axis data sources in Charts

7807 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Brian_Gumm2
4 - Data Explorer
4 - Data Explorer

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…
Screen Shot 2021-11-14 at 10.41.56 AM

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.

39 Replies 39

Hi @Will_Dale thanks for sharing this!

Unfortunately, it wouldn’t work for us as we have such a BIG database already set up with data in different columns, such as income, expenses, profit… by year, so our intention is to layout each of these metrics in the same table as a comparative

Anyone from Airtable team that could give us some feedback on that feature request?
Many thanks

It would be great if you could select which field you wanted to appear on the chart as a series, but that can’t be done yet. Hopefully Airtable will roll this out soon.

Steve_Ruqus
5 - Automation Enthusiast
5 - Automation Enthusiast

Ditto. Don’t make me depend on Google Sheets for charts and graphs! I’m working with a company that sells seats at Live Training (yes we made it through the pandemic, at least so far:-). Customers can buy 3 types of seats. I need to display those.

Michael_Kruse
6 - Interface Innovator
6 - Interface Innovator

+1 for this feature request, it would be very helpful to be able to display multiple metrics on the same chart to save space and allow comparison.

Maxime_Stinnett
4 - Data Explorer
4 - Data Explorer

+1 — It’s crazy that after all this work in Airtable I have to export to Google Sheets just to compare two columns in a chart.

+1; my clients could really use this. eg: compare sales and price offers vs dates

matt_stewart1
7 - App Architect
7 - App Architect

Shocked we don’t have this basic functionality.

AT team please spend a 2 week sprint getting this done. Surely not difficult to add multiple field options in the Y-axis configuration. This really is basic/bog standard functionality we all expect to see here!

VykGlod
4 - Data Explorer
4 - Data Explorer

Yes! This is such a default feature for graphs that it's surprising there is no such feature yet... until this is available AirTable Interfaces are far inferior to Sheets or Excel. Airtable graphs are terrible (but I love everything else!).

Vykintas
4 - Data Explorer
4 - Data Explorer

Yes! This feature is a must for proper interfaces...