Issue with Displaying Percentage Values in Chart Visualization

[lkj6954]

Hello Redash Community,

I've encountered a problem with my chart visualization where the percentage values are not displaying correctly, despite following the typical steps for formatting. I'm trying to include a percentage sign ('%') next to the 'CompletionRate' in my line and bar chart, but it's not appearing after making adjustments in the Visualization Editor.

Here's a brief overview of the process I've followed:

1. I have a SQL query that calculates the 'CompletionRate' as a number between 0 and 100. I've ensured that the query returns this as a numeric value, without a percentage sign.
2. In the Redash Visualization Editor, under the 'Data Labels' tab, I have input the correct format string in the 'Percent Values Format' field (0.00%), expecting this to add a percentage sign to the numeric values in the 'CompletionRate' series on the chart.
3. After saving the changes, the visualization still doesn't show the percentage sign. Refreshing the query and clearing cache hasn't resolved the issue.

Here's the part of the SQL query that handles the 'CompletionRate' calculation:

ROUND(SUM(CASE WHEN o.status = 'completed' THEN 1 ELSE 0 END) / COUNT(*) * 100, 2) AS "CompletionRate"

And here's an example of what the chart looks like currently (attached image). As you can see, the 'CompletionRate' is displayed as a number without the '%' sign, contrary to what's expected.

I would really appreciate any insights or solutions you might have. Is there a step I'm missing, or a known issue with percentage formats in chart visualizations?

Thank you in advance for your help!