Forum Discussion
How to get average CB PVs by PMonth?
Hello, I have the following tables I want to get the average CB PVs per meta ID by PMonth ... it works with the calendar hierarchy and doesn’t with both PMonth and PDate ... why? How to get it ...
johnt75
Super User
Super UserTry changing the relationship between id table and meta to single rather than bidirectional. As it stands any filters on the meta table are passing to the cb table both through the calendar table and the id table, which could introduce ambiguity.
