Hi everyone,
I’m trying to create a line chart in Interface Designer that shows interest rates over time. My table structure is simple:
-
Date (date field)
-
Rate (percentage field)
-
Type (single select)
In the chart settings:
-
I use Date for the X-axis,
-
Rate for the Y-axis,
-
And I apply a filter so that only records with a certain value in the Type field appear.
However, I noticed that Airtable automatically applies an aggregation (e.g., average, sum, etc.) to the Y-axis values, and I can’t find a way to set it to “none.”
Since each date in my table corresponds to exactly one record (no duplicates), I’d like the chart to simply plot the rate as-is, without aggregation.
Is there a way to disable aggregation or make the chart use raw values for each record instead of aggregating them?
Thanks in advance!
