I found the Airtable chart app a little too simplistic - your best bet is to reach out to Airtable Support with a new Feature Request.
Until then, look into the App Vega-lite, although I can’t advise if it’ll structure your chart exactly as desired - I suspect it will. The main problem with Vega-lite is that you’ll need to read the manual, and from my experience it’s not very beginner friendly, however if you have a weekend or two to spare then you’ll hopefully achieve the result you’re after.
Erk, just realised though - I don’t think Vega-Lite can display on the new AT Interface… so back to putting more pressure on Support for both Chart improvements AND supporting Vega-lite in the new Interface.
Welcome to the community, @Brian_Gumm2! :grinning_face_with_big_eyes: This might be doable if you can get the data into a single field, but that depends on the field. (I built a chart the other day that had overlapping values depending on the field content, which is why I think this could work under the right circumstances.)
Before going farther down that road, though, I need to ask: what two field types are currently driving those charts?
Yes! My use case scenario is a little different, but essentially I need the same thing you’ve requested.
I’m searching for a way to display multiple lines of data in a line chart on Interface Designer. Here is an example of the type of chart of I’ve been able to configure so far to show usage of an inventory item using the date field (bucketed by month) for the X-axis and the “Quantity Out” field (sum) for the Y-axis:
Ideally I would like to be able to add more lines to this chart in two ways:
Select a related field as a source for another line on the Y-axis – for instance, show the “Quantity Out” as one line and the “Quantity In” as a separate line (in this case, the label for the Y-axis would simply be “Quantity”). In theory, this approach should support several sources for the Y-axis as long as they all used the same field type.
Set parameters to show a different set of data from the same field that is already being used for the Y-axis – for instance, show FY21 as one line and FY22 as a separate line (in this case, the labels for the X-Axis would still include the month names but no year). This could also be designated by another field if necessary (i.e. I could set up a formula or an automation to categorize each record into the correct “Fiscal Year” and use that field to set the parameters for which records would be summarized into which line, but I would still need a way to configure the chart so that it would look for both the data source field (“Quantity Out”) and the category/parameters field (“Fiscal Year”), which would most likely be a single-select field.
Is there a way to do this? For the sake of simplicity I’ve only listed one example here, but I already have half a dozen use case scenarios waiting for development in Interface that will require the same kind of functionality.
Welcome to the community, @Brian_Gumm2! :grinning_face_with_big_eyes: This might be doable if you can get the data into a single field, but that depends on the field. (I built a chart the other day that had overlapping values depending on the field content, which is why I think this could work under the right circumstances.)
Before going farther down that road, though, I need to ask: what two field types are currently driving those charts?
I’d love to hear more about this chart! Would something similar be possible in the scenario I shared?
I’d love to hear more about this chart! Would something similar be possible in the scenario I shared?
Full transparency: I rarely use charts, and unfortunately I can’t recall a) what situation led me to make the chart that I described or b) where that chart might be located (if it still exists; sometimes I’ll make something as a test, then delete it because it was just a test). If I happen to find it, I’ll let you know, but I can’t promise anything.
Full transparency: I rarely use charts, and unfortunately I can’t recall a) what situation led me to make the chart that I described or b) where that chart might be located (if it still exists; sometimes I’ll make something as a test, then delete it because it was just a test). If I happen to find it, I’ll let you know, but I can’t promise anything.
Fair enough. Thanks for responding nevertheless. 
You could show new vs churned as two separate lines on the same chart. Let me know if this is helpful and I can show you the underlying table structure to achieve this.
You could show new vs churned as two separate lines on the same chart. Let me know if this is helpful and I can show you the underlying table structure to achieve this.
Would love to know how you structured that !
You start with your set of records and tag them as “primary records”. You then need to duplicate the primary records for any dimension that you want to see on the chart. In this case, I have created two duplicate sets of records and tagged them as “new” and “churned”. The new/churned records then need to be linked to the primary records so you can do the relevant roll up. After linking the new/churned records, you do your roll ups, then put all values into one column with this formula: IF({Record Type}=“New”,{New (roll up)},IF({Record Type}=“Churned”,{Churned (roll up)},BLANK())). In interface designer, put the “Customer numbers” field on the Y axis and group it by the “Record type”. Hope that helps.
You start with your set of records and tag them as “primary records”. You then need to duplicate the primary records for any dimension that you want to see on the chart. In this case, I have created two duplicate sets of records and tagged them as “new” and “churned”. The new/churned records then need to be linked to the primary records so you can do the relevant roll up. After linking the new/churned records, you do your roll ups, then put all values into one column with this formula: IF({Record Type}=“New”,{New (roll up)},IF({Record Type}=“Churned”,{Churned (roll up)},BLANK())). In interface designer, put the “Customer numbers” field on the Y axis and group it by the “Record type”. Hope that helps.
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
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.
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.
+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.
+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
Shocked we don’t have this basic functionality.
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!
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!).
Yes! This feature is a must for proper interfaces...
Yes, Airtable, please, get this rolling.
AT please do this, it's a basic function, we need it
+1 on this ask, we aren't able to fully roll out our reporting in Airtable until this is a feature. I love so much about Airtable as a user and creator; however, the interface is the only part of Airtable that our leadership really sees, so it needs to have this functionality.
Is there not a work around for thi? it seems such a standard option from a reporting point of view
Big time need this. Charting right now is just... too basic.
+1 on adding this feature!
