I have successfully used a LOD to calculate the Min and Max of hours by time period for an organizational component (office). However, I have Office setup in a hierarchy with two subcomponents underneath. I noticed when setting up the LOD that the hierarchy title/field (Organization) is not available as a choice.
Is there a way to have the LOD calculate the min and max dynamically based on the level within the hierarchy?
I have successfully set them up simply by duplicating the formulate and adjusting the hierarchy level, but it's not particularly efficient. Especially given I have to duplicate the code to color code the min and max points.