Hello, I use PeopleSoft Insights and OpenSearch Dashboard. I have created a visualization that displays aggregated numeric fields using “sum”. Some of the values show as scientific notation when summing to zero.
I entered a service request with Oracle and was told that this issue has been reported many times but is not something that they will fix. I was told to try math.round but that it didn’t work all the time.
After doing some reading I believe that math.round will round to the nearest whole value. I need my values to round to 2 decimal places.
Since we use PeopleSoft I don’t have access to the developer tools section and will have to apply the fix directly to the visualization. I’m guessing that the json related code should go into the Advanced section of the visualization metric.
Has anyone run into this and how did you fix it. Did you use json in the Advanced section of the visualization? Do you have an example that you can share with me?
Thank you very much for any help you can provide!