Number formatting with Highcharts

[tp_timothy]

Is it possible to format numbers with a comma thousands separator? I’ve run into this with my project but it’s also obvious in Highcharts samples in DemoCentral. See the “High density KPIs” demo for an example - "format": "{point.value:,.2f}" should result in a comma for thousands separator but it rendered with a space separator.

I’ve reviewed previous related questions but the workarounds either don’t apply in all cases or don’t seem to fix the problem.

Formatting numeric values in a QuickSight Highchart

Looking for a way to display numeric data labels in a Highchart visual with commas as the thousand separator. The current format entry “format”: “{point.value:,.2f}” looks as if it should show a value with commas and 2 decimal places, but spaces appear.

Highcharts language configuration: thousandsSep

Hi, The newly added feature for incorporating Highcharts visuals in QuickSight is fantastic! I believe it’s one of the most valuable updates introduced in recent months. I’ve been exploring it and tried using examples from Demo Central as well as adapting code from the Highcharts website to work in QuickSight. However, I’m encountering some challenges. I understand that Highcharts in QuickSight only supports valid JSON, which means functions aren’t currently supported. For instance, in Highc…

[duncan]

Hello @tp_timothy

After a lot testing on my end I’m pretty sure this is a bug of some kind. I would recommend creating an AWS support ticket.

Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf.

[tp_timothy]

Thanks @duncan! That’s how it looked to me as well. I wasn’t sure how to proceed with opening a ticket, so this is helpful.

[Hrolol]

You could try to create a string columns with a formatted value in your SQL query or using a calculated field (actually not a good idea How to keep comma separator after using tostring() function? ). So you will use something like this: “format”: “{point.myFormattedValueWithComma}”. But it will work for you if you do not aggregate data in your visual.

[tp_timothy]

Thanks @Hrolol, you nailed the problem with this approach (at least in our case). We are doing aggregations within the visual so pre-formatting in SQL isn’t really an option.