1 Reply Latest reply on Feb 11, 2019 9:45 AM by Diego Parker

    Spark Lines with Min/Max per LOD and hierarchy?

    David Mouser

      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.

       

      Thanks.