I have a database in Airtable that has two values per record. I’d like to make a line chart of these two values with a line representing the max value of each of these columns grouped by the created_at timestamp. (I could live without grouping).
The UI shows two lines in the line chart - but I haven’t figured out how to add a second series. It seems that only a single series (“metric”) can be added.
It /seems/ like I would be able to add a second metric here in the UI:
In this particular case, each row is used to record the temperature at two different locations with a timestamp. I’d like to make a chart with a separate line for each location with the value being the max temperature recorded for day.
Hey, Here’s an example to explain your case. You want to organize the data by date and location. Each location has a specific temperature recorded for that date. For the X-axis, you can choose the date (or the reverse), and for the value, select the temperature since it’s a numeric metric. You need then to apply an aggregation method, such as calculating the average or summing up the data.
If you want to show multiple values based on location, you’ll need to create subgroups. Assign the location field to this subgrouping, which will generate distinct lines for each location. Refer to the screenshot for a clearer understanding.
