Is it possible to move a decimal place using the table number formatting in Redash?
Here’s the scenario I’m dealing with: I’m using the JSON data source and query parameters to fetch data on-demand from a third-party API and display it in a dashboard. That API is returning US currency in cents instead of dollars (e.g.
$10.56 is being returned from that API as
I can’t figure out any way to use the number formatting options to move the decimal place so that the currency appears correctly in the table visualization. Fetching the data from the API in advance and then using the Query Results source to manipulate the number is not an option. The data must be fetched on-demand.
Any ideas? Workarounds? Or am I out of luck . . .?
- Redash Version: v10 beta