Transformation is not working when source is google sheets

[jayjoshi7064]

This is my first post, let me know if I did something wrong.

I am trying to create dashboard from a google sheet. the data is import fine. but any transformation is not working.

Example,
I am trying to import my expense tracking sheet where it has data for each category

but when I try to group data by aggregation (total), everything is 0.

Unexpected result:

I have applied a bunch of forumulas to the spreadhseet. but the value is ultimately a float / integer. Grafana is able to parse it when I don’t apply any transformation then why it stops working when I do apply?

[jayjoshi7064]

It was not working because all fields coming from spreadsheet are by default string.
For any operation, you’ll have to convert them to the correct type.
After converting those fields to number, things started working.