CODEWITHSUNDEEP
looker-studio
Jeremy Lewi
Jeremy Lewi

Reputation: 6766

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

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?

Upvotes: 6

Views: 11469

Answers (3)

Raman
Raman

Reputation: 19585

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.

Upvotes: 0

Nimantha
Nimantha

Reputation: 6461

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:

Upvotes: 2

Elena
Elena

Reputation: 31

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

Upvotes: 3

Related Questions