I want to add a field where it calculates the count of records based on a specific field.
Let's say that I have 1000 records.
And in 3 of the records, the value in one of the field is "Yellow" so I want a field that display 3 based on the count of records that match "yellow" in that specific field.
I also want to add one more criteria, the "created date".
I've looked at count-function, but the seems only to count within the record. (I always get value "1").
I did some reading and I suspect that I've to use relations.
I'm not very good in using relations, so I may need some help here.
Last edit: Solved everything.