Calculating Occurrences of records

[Jim_Gall]

Hi there

Is there a way I can tally the occurrences of a record within a column?

For example, if I have a column called ‘colours’ and it has five reds, three blues and two yellows, how can I count these and disp[lay within a record (probably on another tab called ‘Calculations’)?

Thank you in advance.

[TheTimeSavingCo]

Hi Jim, if I were you I’d link all of those records to a single record in the Calculations table, and then use conditional Rollups or Count fields to count the occurences of each color

[Jim_Gall]

Thanks for your reply - but I’m pretty new to this - do you have a step by step?

[ScottWorld]

@Jim_Gall

Do you really need the calculations all in the same record? If not, the easiest way is to just convert your field into a linked record field, and when you are prompted for which table to link to, create a new table called Calculations.

Then, in your new Calculations table, you can add a field of type “Count”.

[Jim_Gall]

Thanks @ScottWorld I think I’m finally getting it! :slightly_smiling_face:

Also - I have a revenue field (column in Excel) - how could I add the total revenues in currency?

[ScottWorld]

You would use a rollup field:

support.airtable.com

Rollup Field - Overview | Airtable Support

A rollup field performs calculations, creates aggregates, and builds formulas on specific cells from records that are linked to another...

Since you are brand new to Airtable, I would highly recommend taking my free Airtable training course, where you will become an Airtable expert in 90 minutes:

LinkedIn

Learning Airtable Online Class | LinkedIn Learning, formerly Lynda.com

Learn the basics of Airtable, a spreadsheet-database platform, including how to create tables, use different types of fields, leverage views, work with records, link tables, and more.

[Jim_Gall]

Sold! @ScottWorld thanks for your help.

[Jim_Gall]

Thanks for your help on the above @ScottWorld - I have another question. Is there a way I can tally occurrences with some sort of conditional? e.g. If I have Blue1, Blue2, Blue3, Red, Yellow1, Yellow2.

Can I somehow tally the total number of Blues even if they are not identical record names? TIA.

[ScottWorld]

You can group by that field in Airtable, and Airtable will automatically create summaries of each group for you with the summary bar: Summary Bar - Overview | Airtable Support

[Jim_Gall]

I don’t think the summary bar will be of use for this as I want to use the counts in a third party software which displays values in a dashboard.