Count how many times two reference fields are used?

497 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi all!

I have a table of records that has a few hundred entries. These entries essentially connect two tables, the “Websites” and the “Elements”. In my main table, I connect those two reference fields to each other and have for example: Netflix (website) | video player (element). What I’m looking for is a way to be able to count how many times those two combinations have been used with each other. If you can imagine, I’d have 10 different records of different versions of Netflix + Video player, so I need to be able to have a formula with something similar to {websites} & " - " & {elements}, count up. End result should be something like:
Netflix-Video Player-1
Netflix-Video Player-2
Netflix-Video Player-3
Keep in mind, there are many different website names, and many different element types. So each website + element should be able to be counted for individually.

Let me know if that makes more or less sense! Thank you :slightly_smiling_face:

0 Replies 0