Skip to main content
Solved

How to build multi-series line charts

  • July 17, 2023
  • 4 replies
  • 400 views

Forum|alt.badge.img+2

Trying to build a Multi-series line charts. I found articles from 2022 announcing it as a feature in interfaces but can't find any information about how to do it. I don't see an option to add an additional data set. Does anyone know how to implement this? 

https://blog.airtable.com/interface-designer-product-updates-1/

Thanks!

Best answer by TheTimeSavingCo

 

Try using the "Group by" dropdown:

Gives me this:


Based on this:

4 replies

TheTimeSavingCo
Forum|alt.badge.img+31

 

Try using the "Group by" dropdown:

Gives me this:


Based on this:


Forum|alt.badge.img+4
  • Participating Frequently
  • July 20, 2023

 

Try using the "Group by" dropdown:

Gives me this:


Based on this:


Is it possible to create a stacked line chart in the interface based on several fields/columns from the same table in a base?

I created a stacked line chart using Vega-Lite in the dashboard in the base, but I would like to do the same in the interface. Additionally, Vega-Lite is not interactive, so I cannot see the exact values when I hover over the lines/data points.


TheTimeSavingCo
Forum|alt.badge.img+31

Is it possible to create a stacked line chart in the interface based on several fields/columns from the same table in a base?

I created a stacked line chart using Vega-Lite in the dashboard in the base, but I would like to do the same in the interface. Additionally, Vega-Lite is not interactive, so I cannot see the exact values when I hover over the lines/data points.


> Is it possible to create a stacked line chart in the interface based on several fields/columns from the same table in a base?

Heh to deal with this I usually create another table that compiles all of the data from those fields into a single field with a single select to differentiate each field.  I then group by that single select, thus creating the stacked line chart

Not the most elegant, but it works!


Forum|alt.badge.img+4
  • Participating Frequently
  • July 21, 2023

> Is it possible to create a stacked line chart in the interface based on several fields/columns from the same table in a base?

Heh to deal with this I usually create another table that compiles all of the data from those fields into a single field with a single select to differentiate each field.  I then group by that single select, thus creating the stacked line chart

Not the most elegant, but it works!


Hi Adam,

Thank you so much! I tried it out and it works. You're a lifesaver!