Good morning, everyone. I saw a post in this Metabase forum from four years ago where someone asked if it was possible to rename columns after performing a join in the editor, as the relationship would still appear when creating a table for user display. I’m facing the same issue/question—currently, my tables display the joined column names in this format. Is there a way to rename them, or is there any workaround for this?
I do have a potential solution by using an SQL query, but I can't fully implement it because I'm unable to apply a (between dates) filter, for example, 02/20/2024 to 03/17/2024.
I’m not fully clear on the concept of using filters with one or multiple "WHERE" conditions in the query, as whenever I try to include the filter, it breaks or causes an error when adding the filter condition.
SELECT
s.sensor_name,
mc.timestamp,
mc.temp,
mc.ph,
mc.cond,
mc.odcpt,
mc.odmgl,
mc.redox,
mc.turb,
mc.tds,
ml.ammonia,
ml.e_coli,
ml.dbo,
ml.total_phosphorus,
ml.nitrite,
ml.nitrogen,
ml.total_sol
FROM
public.sensors s
LEFT JOIN
public.measurements_common mc
ON s.id = mc.sensor_id
LEFT JOIN
public.measurements_lab ml
ON mc.id = ml.common_measurement_id
WHERE
mc.is_lab_measurement = TRUE
Best regards,
Matheus
