I have found that when setting up a Database Information Field with Database Child Information fields the Information Field show up in Dashboard Gadgets, such as pie charts, heat maps, and two dimensional tables. On the other hand the Child fields just do not. I have tried a few things to make it work without any luck.
- I changed the Search Template.
- I used a "Text Field" instead of a Child Field to be populated as a child.
(This seems to work in the Issue but not for the Gadget) - I did re-index on each change.
- I have seen this issue in 6.3.1 and recently tried in 6.4 as well.
Any ideas? My next bet would be to make each field a stand alone Database Information Field which would work but not be as elegant and would increase the number of SQL statements.