I have a content type with a math expression field (from Math Field module) that takes numerical input entered by the user on the creation form, performs a simple calculation, and outputs a number. In all respects, the field behaves like a numerical field. It has a number kind of formatter. I am able to use it as the numerical value with views Charts displays.

When creating a Views Simple Chart views display, I encounter an error, "Data column(s) for axis #0 cannot be of type string." I believe that VSC is seeing my math expression field as a string field. I have tested my understanding by replacing the calculated field with a numerical field that is directly entered by the user; in which case the chart displays correctly.

Is there any way that I can overcome this?

Comments

mastoll created an issue. See original summary.

mastoll’s picture

I found my solution.
When configuring the calculated field, I had added a comma as a thousands separator. Not allowed!

'Hope this helps someone else!

_shy’s picture

Status: Active » Closed (outdated)

D7 reached its EOL back in January 2025, and there is no active release for D7 for this module anymore.
Development or support is not planned for D7. All D7-related issues are marked as outdated in a bunch.

If the issue remains relevant for D10+ versions, merge requests with proposed solutions for a new module version (D10+) are welcome in a new follow-up issue.

Thanks!

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.