Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I combine values within the same column? I am creating a sheet on a public app that does not belong to me. I do not think I can access script editor. I think I can only write dimension and measure expressions to modify a table and pie chart.
Animal | Trait |
Tiger | Orange |
Bird | Orange |
Bird | Feathers |
Tiger | Fur |
I would like to get the above table to look like the table below.
Animal | Trait |
Tiger | Orange, Fur |
Bird | Orange, Feathers |
I also want to create the following pie chart: Orange: 50%, Fur 25%, Feathers 25%
Thank you for the help.
As below
Dimension:
Animal
Measure:
=Concat(Distinct Trait,',')
Hi,
You can use:
Dimension: Animal
Measure: Concat(Distinct Trait,',')
and for the pie diagram
Hope this helps,
help user find answers ! don't forget to mark a solution that work for you and click the like button!
Do you know how to create the second table?