How to Group on Table

  • 2 June 2022
  • 4 replies

I need to group by state exactly like this. How do I make a table report look like this? When it expands, all the addresses are displayed.


Best answer by Michael Ullock 7 June 2022, 09:47

View original

4 replies

Userlevel 1

Please see the following documentation that will help you with creating Table reports:

Tables automatically adjust the width of all the columns according to the cell content. The size is calculated according to the content in the header of the column that represents the lowest level of the grouped attributes. More details can be found in the article above. 

If the above article doesn't help, can you please provide more details? In this screenshot take a look at the date column. It has a ‘group by’. I think that’s what I need; however, instead mine would be grouped by state code. I don’t see this option or any options at all when trying to create a table report.



There is no option for me to group by...

Userlevel 1

The option to "Group By" is only available to Date Dimensions - this is why you cannot see this there. 

I would like to mention that it is possible to filter your metrics using many different FILTER EXPRESSIONS. You can filter for specific attribute values using the WHERE CLAUSE. There is also great free tutorial you can take on our MAQL Language, in our GoodData University.