I have some Boolean and string variables that I want to display in the info window on carto db. But it seems to be only showing one individual data point. How do I get it to show modes or averages of the entire data set?
You need to add some SQL to make that information available. If you open the SQL tray and change
SELECT * FROM your_table to:
SELECT *, avg(interesting_column) OVER () AS table_avg FROM your_table
Now toggle the new variable on in your infowindow to make it available. Just fill in
interest_column with the numeric column you want information from, and make sure to update
your_table with the appropriate name.