grafana-aws-athena-datasource icon indicating copy to clipboard operation
grafana-aws-athena-datasource copied to clipboard

Date format - Invalid Date

Open pedroabi opened this issue 4 years ago • 0 comments

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 image

pedroabi avatar Jul 28 '20 13:07 pedroabi