LEVEL_ERROR message: "components.PieChart: Data invalid. Each pie section object must have a label (string) and a value (number)"

[jseffinga]

I found an issue with the pie chart im looking for help with.

I have a pie chart and an SQL query.

The query is this

Table has both varchar data types.

When i bind the data to the pie chart no matter what post process manipulation i do it give me this error.

ERROR Perspective.Designer.Workspace -- level: LEVEL_ERROR
message: "components.PieChart: Data invalid. Each pie section object must have a label (string) and a value (number)"
line_number: 2

Found out its because even tho my data types are char the pie chart keeps automatically changing my badge number to an int since the ones in the table dont have letters in them.

if i add one with a letter in the table its all fixed otherwise doesnt work.

Any Suggestions?

[JordanCClark]

You can try concatenating a nonprintable character to it:

SELECT
    CONCAT(badge_number, NULL) as badge_number,
    COUNT(*) as count
FROM HS1_6SPD_BADGE_TABLE
GROUP BY badge_number

Trying it through an expression seems to keep it as a string: