grafana-aws-athena-datasource
grafana-aws-athena-datasource copied to clipboard
Date format - Invalid Date
This is my query:
SELECT
to_iso8601(date_trunc('day', from_iso8601_timestamp(deployday))) as deployday,
count(*) AS deploy_freq
FROM "donus-prod-statshook-db".jenkins_deploys
LEFT JOIN "donus-prod-statshook-db".tribe_service
ON trim(tribe_service.repository) = trim(jenkins_deploys.repository)
LEFT JOIN "donus-prod-statshook-db".github_pushes
ON github_pushes."headcommit.commitid" = jenkins_deploys.commit
WHERE
"headcommit.message" NOT LIKE 'Revert%' and
github_pushes.branchref = 'refs/heads/master' and
jenkins_deploys.repository not in ('donus-github-statshook')
GROUP BY 1
order by 1 desc
This is my resultset:
deployday | deploy_freq | |
---|---|---|
1 | 2020-07-28T00:00:00.000Z | 1 |
2 | 2020-07-27T00:00:00.000Z | 2 |
3 | 2020-07-23T00:00:00.000Z | 1 |
I have setup Timestamp Solumn as deployday and Time Format is blank.
The graph is working, but when I pass the mouse over the graph it shows