This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
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". ...
