Skip to main content

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!

Are you saying that you only have one rate record for each distinct date? If so — if you only have one record for each date — you can use the “Average” aggregator, because if you average just one value, you will get that exact value.

- ScottWorld, Expert Airtable Consultant


Hey ​@amanda_chp,

I should plot this out, but if your table has only one record per date couldn’t you just keep Sum? E.g. sum of 2% is still 2%, right?

Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel


Yes, sum would work too! :) Sum or average would be your 2 best choices here!

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


That works! Thank you so much for the help, not sure why I didn’t think of that before. Really appreciate your quick response!