When using the JSON data source and querying an API can you can’t cast a text value to a number. I have tried using a Query data source to query the results and casting the text value to a number but it fails and returns only zeros. The same happens for most SQL functions.
- Redash Version: 8.0.0+b32245 (a16f551e)
- Browser/OS: Chrome
- How did you install Redash: Docker