Group By [Split Text] Column

Hi! I’m writting this because I have some records of cinema sessions and the days that this session is made (maybe a session at 16 is only for friday and sunday nor saturday). As it’s seen in the screenshot I have the days (in catalan) in a comma-separated text column and I use the Split Text by comma to split the days.

But when I want to display that in a inline list and grouped by this Split Text column (in order to see that on friday i have the session seen before at 16 and another one at 18 that is for fridays and saturdays only).

My objective is to get an inline list like (for example):
Friday:

  • 16:00
  • 18:00
    Saturday:
  • 18:00
    Sunday:
  • 16:00

Thanks in advance and feel free to ask if you need some more information.

I don’t think that’s going to work. If I understand, you are trying to show the same row multiple times in a single list. You can’t force a row to show in a list more than once. You would need to either create separate rows for each time and day, or create multiple lists that are each filtered to only show one day for each list, and only those times that include that day. You probably wouldn’t need the Split Text column in that case.

2 Likes

Oh thanks, I’ve trying a bit and it’s possible to in-app filter by that split column and each time are show in both filter days but not group by them. I think i’m going to separate them into single rows. Thanks @Jeff_Hager

1 Like