Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can not get the minimum or maximum of datetime #4482

Open
sailxjx opened this issue Mar 3, 2017 · 3 comments

Comments

Projects
None yet
5 participants
@sailxjx
Copy link

commented Mar 3, 2017

Bugs

If you're filing an issue about a bug please include as much information
as you can including the following.

  • Your browser and the version: (e.x. Chrome 52.1, Firefox 48.0, IE 10)
    Chrome

  • Your operating system: (e.x. OS X 10, Windows XP, etc)
    OS X 10.12.2

  • Your databases: (e.x. MySQL, Postgres, MongoDB, …)
    Redshift

  • Metabase version: (e.x. 0.19.3)
    0.22.2

  • Metabase hosting environment: (e.x. Mac app, Elastic Beanstalk, Docker, Heroku, Linux/Ubuntu 12)
    docker

  • Metabase internal database: (e.x. H2 (default), MySQL, Postgres)
    h2

Hi, guys, I can only find the numeric fields in the builder when I chose minimum of, however min(datetime typed fields) is supported in sql editor. Why does this happend?

2017-03-03 16 32 17

2017-03-03 16 40 08

Finnaly, thanks for your great job and product.

@sksembhi

This comment has been minimized.

Copy link

commented Mar 26, 2018

  • 1 need this.
@emetselaar

This comment has been minimized.

Copy link

commented May 8, 2018

Would be nice to have this. I use it to create a tile in a dashboard that indicates until when the data is updated. This can be done with SQL, but not all users are allowed to run SQL, so they get "no permission" in that tile.

Workaround for other people who might need this, create a view in your source database with max date.

@flamber

This comment has been minimized.

Copy link
Contributor

commented Feb 18, 2019

Another workaround is to create a Custom Expression:
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.