Hi All,
I am trying to create a bubble chart using highcharts and want to format the tooltip value to percentage format. How do I set this up ?
“tooltip”: {
“useHTML”: true,
“pointFormat”: “{point.name} {point.value:,.2f}”
}
What changes are needed in the format to achieve this?
Thanks,
Prantika
duncan
December 18, 2024, 5:57pm
2
Hello @prantika_sinha !
Can you try adding a suffix? Something like below:
valueSuffix: ’ %',
“tooltip”: {
“useHTML”: true,
“pointFormat”: “{point.name} {point.value:,.2f},
“valueSuffix”: ’ %’
}
1 Like
That did not help. ‘%’ is throwing error, so tried with “%” as well.
1 Like
duncan
December 18, 2024, 8:00pm
4
Hey @prantika_sinha !
What’s the error and what does the code for your tool tip look like?
Here is the code I used:
{
"chart": {
"type": "packedbubble"
},
"tooltip": {
"useHTML": true,
"pointFormat": "<b>{point.name}</b>{point.value:,.2f}",
"valueSuffix": "%"
},
"plotOptions": {
"packedbubble": {
"minSize": "30%",
"maxSize": "3000%",
"zMin": 0,
"zMax": 1000,
"layoutAlgorithm": {
"splitSeries": false,
"gravitationalConstant": 0.05
},
"dataLabels": {
"enabled": true,
"format": "{point.name}",
"filter": {
"property": "y",
"operator": ">",
"value": 250
},
"style": {
"color": "black",
"textOutline": "none",
"fontWeight": "normal"
}
}
}
},
"series": [
{
"name": "Series1 ",
"data": ["getColumnFromValue", 0]
},
{
"name": "series 2 ",
"data": ["getColumnFromValue", 1]
},
{
"name": "series 3 ",
"data": ["getColumnFromValue", 2]
}
]
}
This is not throwing error, but the values in the tooltip is appearing in decimal which I want to be in percentage.
When I try adding suffix using single quotes, I believe the syntax is not correct throwing the error like :
@duncan Any suggestion to fix this?
duncan
January 7, 2025, 7:12pm
7
Hello @prantika_sinha !
I’m sorry about the late reply! Were you able to find a solution or workaround? I’m basing this off of the documentation available from High charts. It’s possible that this needs to be a feature request for the QuickSight team.
No luck yet! Thanks for checking
1 Like
duncan
January 7, 2025, 7:17pm
9
@prantika_sinha no problem, I’ll go ahead and mark this as a feature request for the QuickSight team!