Hello, I have a table with N related records. In the related records there’s an EnumList type column with maintainance tasks done separated by a comma. I want to find out how frequent is a task is to analyze datas and have a first insight of the most common problem. I’ll attach a screenshot of the columns with tasks separated by commas.
Thanks in advance
Such expressions could be long. Just for updating the community, could you update how many total options are there in the enumlist column and what are those options. If those options are 4 or 5, some expression could be possibly tried.
Also are you looking for frequency in just one parent record’s related records or frequency of related records of all parent records together.
Edit: Also please update where you would like this frequency to be displayed- in the parent table or in the child table itself.
