Fields not loading from collection

I am trying to create some charts based off of my documents in my database. Unfortunately, some of my fields cannot be found by charts. For example, I want to make a chart using the field highlighted below.

But when I try to find the field, it does not show up in charts, see below:
Screenshot 2024-04-19 at 4.26.07 PM
I’ve even tried to add the field, but for some reason, it cannot find it in the database:
Screenshot 2024-04-19 at 4.26.21 PM

I’m having trouble with some fields but others in the same database, I can access easily.
Would appreciate any suggestions - thank you!

Hi @Sidhika_Tripathee -

Charts does not support fields that have dots in their names. These are technically legal but cause a lot of problems with aggregation pipelines, since the dot (and dollar) symbols are used for other purposes.

To get this working, I’d suggest creating a Charts View which uses $set and $getField to project these long field names into shorter names without problematic characters.


Great, thank you so much!

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.