Sql question


I created an sql question: sql_periodDate. When I want to create a chart I do not have all the fields available.

select *, STR_TO_DATE(periodDate, '%d/%m/%Y') as periodDate_date
from `table 1`

I get all the fields

When i explorer data, I only have periodDate_date field.

I want to create a custom expression with sumIf() and traf_aer_fret but it tells me that the field is not found.

When i do a Sum of... he finds the field traf_aer_fret