Hi @matheushrd
Please post “Diagnostic Info” from Admin > Troubleshooting.
And which version of Athena driver you’re using.
Check the browser developer console for errors, when you try to enable Trend visualization.
@matheushrd
Latest release of Metabase is 0.37.0.2.
Latest release of Athena driver is 1.1.0, which is only fully tested with Metabase 0.36
Try upgrading - remember to backup before upgrading.
SELECT COUNT(*) as "Contagem_objetivo",
date(cast(SUBSTRING(timestamp,
1,
10) AS timestamp)) AS criado
FROM "roads-be-db"."objective"
WHERE ( date(cast(SUBSTRING(timestamp,1,10) AS timestamp)) BETWEEN (current_date - interval '14' day) AND (current_date - interval '7' day)
OR
date(cast(SUBSTRING(timestamp,1,10) AS timestamp)) BETWEEN (current_date - interval '7' day) AND (current_date)
)
GROUP BY date(cast(SUBSTRING(timestamp, 1, 10) AS timestamp))
ORDER BY date(cast(SUBSTRING(timestamp, 1, 10) AS timestamp)) ASC