2 Replies Latest reply: Aug 1, 2013 2:02 PM by Shannon Lepore RSS

    Help with chart expression - need max effective date

      Hi,

       

      I have a chart where I have

       

      Max(End_Time)-Min(Start_Time)

       

      as the expression.

       

      I’ve attached an image below.

       

      I need this chart to ignore selections in the document and always display the chart based on the max effective date.  I have list boxes set up using the effective date so users can select dates.

       

      Is this possible?  I know that you would usually include a 1 identifier in your set analysis to achieve this but I’m not clear on how to include this in my chart expression since I’m not aggregating anything.

       

      Also, would a better approach be to create a standalone table to hold the latest data? I’m not sure how to do this but this was a suggestion I received.

       

      Thanks in advance for any help.

       

      Untitled.png