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