How to convert 'str' to 'int' in [custom question]?

1

I want to convert 'str' to 'int',
but I failed.
try:
'str' + 0...--'str'...function: convert, cast...

image
image934×672 40.3 KB

I am helpless...

OR
How to use the result from custom question in native query?

2

Hi @JayceS
These are the functions available in Metabase:
https://www.metabase.com/docs/latest/users-guide/expressions.html
There's currently no casting/convert functions available.

3

Thanks~
Yes, I have read all the doc but no use...

4

@JayceS If you have read the documentation, then you would see that there's no cast function. You would have to do such conversion in SQL or with a database View.

5

:woozy_face::woozy_face::woozy_face:

6

= energy_cost_str *1

7

@zackdai That's only possible for database types, which allow loose casting. Would fail on Postgres.