Horizontal bar chart with just one dimension in Google data studio (looker studio)-CodePudding

I hava dataset with emails and level of expertise

Emails                    Level of expertise 
[email protected]            Beginner 
[email protected]            Intermediate 
[email protected]            Intermediate 
[email protected]            Advanced
[email protected]            Beginner
[email protected]            Intermediate 
[email protected]            Advanced

I want to create a horizontal bar chart with just one dimension as shown below

Right now what I am doing in data studio is

and that generates this graph

Any help would be appreciated thanks

CodePudding user response：

You can create a new column of data using a calculated field as shown below and then use it as dimension to achieve the intended design chart.

REGEXP_REPLACE(Date,"[\\s\\S] ","Level of expertise")