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.

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 “n...

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.

Thanks @Rebecca_Meritz, I actually tried to modify the script to pull data from a separate “templates” table. I think the solution where the templates just sit in the same table is more efficient, so this script works perfectly. Thanks for responding...

Very useful, thanks. How would you change the script if the Days Out field in the Projects table is a single select field type? I still want all the same Days Out values that appear in the template, but they need to copy across to a single select fie...