Hello,
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:
I’ve even tried to add the field, but for some reason, it cannot find it in the database:
I’m having trouble with some fields but others in the same database, I can access easily.
Would appreciate any suggestions - thank you!
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.
