2 Replies Latest reply on Nov 3, 2018 3:45 PM by Josh Ciszek

    The old overlapping values issue...with a twist

    Josh Ciszek

      So, I've been reading about the various overlapping value issues...but I fear my issue will be a trade-off between 2 requirements of the workbook...

       

      I'm trying to add the Average LOS (Length of Stay) to the "Level of Engagement" worksheet, per Program.  As you can see, I'm getting overlapping values and it is because of the ClientID dimension in the Details shelf.  The problem is that the ClientID has to be there in order for Action Filters to work on the subsequent worksheets (Action by Engagement & Action Change).

       

      Is there a way around this...so that I can clearly show the Avg LOS for each Program?  It's interesting that it has the right/clear number in the Tooltip.  Thanks in advance.

       

      Picture1.png