currently I am running a survey.
In my raw data (table name = “Chat feedback”) set I have the column:
In the same table I have the column:
Now I wanted to create a result table to summarize the data (table name = . As the priority is ordinal scale level I wanted to calculate the median by title.
So i tried this:
The formula in filter does not work. I tried it separately in another column and it shows “false”. The columns formats seem to be correct (I basically had the same format constellation in another doc, where it worked).
Can anyone help me? I tried several formulas, but I don’t get the result I want.