This is hard to explain, so I’m sorry if this is confusing.
I have two custom modules where one is related to Accounts (which I renamed to Institutions) and it is related to another module named Sprints.
Institutions (Accounts) is related to Deployments which is related to Sprints.
When I create the module Sprints in Module Builder, I made a field named Go Live Date. When I deployed the module, I realized I made Go Live Date to a text field, not a date field. So, I went to studio and created a new field named Go Live 2, which is a date field. So, Go Live 2 is now a custom field.
Now, I create a report on Deployments. The fields I used is Account:Name, Deployment:Name, Sprint:Name. This report works. No custom fields. It brings back the data I was expecting.
I now create the report with the same field as above and added Sprint:Go Live 2. This report does not work. Go Live 2 is a custom field. I went back and removed that field and added a custom field from Account, and it broke the report, also. When I say it broke the report, I mean it returned no results.
Also, I did not add any conditions.
If you need any other information, please let me know.