How can I sort a table in Datastudio by multiple columns?

Question

I have a report in Datastudio that consists of multiple columns. I'd like to sort the rows based on multiple columns. Is it possible to do this?

score 3 · Answer 1 · answered Oct 04 '17 at 01:25

3

The sorting is limited by 2 columns. In the Table Properties-Data pane pick "Sort" and "Secondary Sort" options for primary and secondary sorting.

answered Oct 04 '17 at 01:25

Elena

31
2

score 2 · Answer 2 · answered Jun 24 '20 at 08:38

As noted by Elena, Tables allow editors to set a default (Primary) Sort and an optional Secondary Sort.

In addition, while in View Mode, users can also sort the Table as required, by either tapping on the respective field header, or by accessing the Sort Drop-down in the Chart Header.

Google Data Studio Report and a GIF to demonstrate:

score 0 · Answer 3 · answered Mar 24 '21 at 16:09

As previous answers have stated, it looks like Data Studio only supports two sort fields.

You can create a calculated field on the secondary sort, which concatenates together the 2nd and subsequent fields on which to sort by, to approximate sorting on more than two dimensions.

How can I sort a table in Datastudio by multiple columns?

3 Answers3