Grouping multiple lines by date or summing column

[robertr1]

Hello all,

Struggling here with Looker and trying to combine multiple rows. The data I’m working with is survey-scores by date. What I’m getting is something like this:

Date        Knowledge      Friendly        Caring

11/6        4                        3                    4

11/6        4                        1                    1

11/6        3                        3                    3

11/5        1                        1                    1

These are all dimensions by the way. I’m told they are split on different lines even though they are all the same date because the combination of scores is unique.

What I’d like is to group them and have a sum instead with one line per date:

Date        Knowledge      Friendly        Caring

11/6        11                      7                    8

11/5        1                        1                    1

Thanks for reading.