stacked bar chart

[Thay3]

Hello. I have a database in Sheets that contains responses about mental health. There are 5 variables. The responses are related to risk, and can be "Low", "Moderate", "High" and "Extreme". In other words, the database has 6 columns (ID, RISK1, RISK2, RISK3, RISK4, RISK5). I need to create a stacked bar chart: each bar represents a RISK (5 bars) and each color of the stacked bar corresponds to the number of people for each level of risk. I created a second "melted" database to do this, but since I use filters and the graph has to change based on the selection of these filters, it cannot be a separate database. 

[Looker_Studio_B]

Unsure what's your problem here, can you describe the expected outcome and why you can't reach with stacked bar chart?

[Thay3]

Looker could not "read" my data in the standard format to create stacked bars (variables in the columns and cases in the rows). So I had to melt the database: the first column was the case, one column was called "variable", and another "risk level". But to do this I had to create a second database. And I couldnt use the filters, which were in the first one. The solution was to bring all the filters to this second melted database as well. Now it works.