Data Studio
3.8K members online now
3.8K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

getting a list of unique values from multiple dimensions in data studio

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hey all 

 

So I'm having a small but frustrating problem. count the number of mentions of unique values but they appear across multiple columns (dimensions). I can't find a way for data studio to pull together all the unique values while still keeping it as a dimension. I need the output to stay as a dimension so as to chart it against a metric I have to count the totals. 

 

Any help would be great as I have tried quite a few iterations of count and count distinct but they all create metrics, nothing combines and stays as a dimension. 

 

thanks!

getting a list of unique values from multiple dimensions in data studio

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Same issue here, i have several events in a table, each event can have up to 5 guests, their names will always be changing and i need to get a pie chart showing the most frequent names in all of the events, but i can't find a way to JOIN or MIX my dimensions guest 1, guest 2, guest 3, guest 4 and guest 5. Aparently the best you can do is have 5 pie charts to display the data... but then the same name might show up in multiple charts.