I am trying to find a simple way to calculate the average of selected columns (avg per row) dynamically in CARTO, using only the pre implemented features of CARTO Builder so that it is as user-friendly as possible and does not require manually running SQL code for each calculation.
My underlying dataset contains several columns
score1, score2, etc. I would like to compute a new column
avg_selected_cols based on the user input (say columns
score4) that contains (
score4)/3. Ideally, the columns should be selected through some widget to make it as easy as possible.
So far I am using a sync table from Google Drive that calculates this average with
AVERAGEIF clauses based on a row where I just set an "x" for each column I want to include. Synching from Google Drive, however, can be done at most every 15 minutes but I need the map/ data to update almost instantly.