I have been using airtable for a while now, to collect data about certain objects in a base with grid-view. Each line represents one object and I have different rows, characterizing the objects in different dimensions.
Most of the rows are “multiple select” options with a max of 25 options which are freely combinable.
So basically I have a base with around 120 instances and each instance is characterized in different dimensions.
My interest now is to find clusters in a certain dimension which means I want to learn which options in a dimension have often been selected together. Is there a way of getting this done in airtable? The standard “group by” feature is working for dimensions (rows) where not many options are selectable but for dimension with more options it does not work in a sufficient way.
I have difficulties in finding out if there is an app which could support my intentions. Also i have a free plan for now and can not just test around with different apps. Does anyone know if there are apps that could help me with that analysis in airtable? If I knew there is an app I would consider getting a pro plan.
Thanks in advance for your help!