1 2 Previous Next 16 Replies Latest reply on Oct 12, 2016 10:54 AM by Peter Gabe

    Level of Detail Expression Alternative. Help needed.

    Peter Gabe

      Hi. I was hoping somebody could help me with the following situation:

       

      I have two dimensions. [Iteration Number] and [Outcome] in a hierarchy and metric [Hit]. So various outcomes form an iteration number with a total hit count against it. So for example:

       

      [Iteration Number]       [Outcome]         [Hit]

       

      5                                       a                    3      
                                                b                    3

                                               c                    3

       

      6                                       d                    2

                                               e                    1

       

      I need to make a calculation that does the following. If an outcome contains 'b' or 'e' I want 'f' to be assigned against it: So the above would look like this:

       

      [Iteration Number]       [Outcome]         [Hit]

       

      5                                       a                    3      
                                              f                     3

                                               c                    3

       

      6                                       d                    2

                                               f                     1

       

      I  also need to make a calculation that does the following. If an outcome contains an entry, let's say 'f', then I want all of the outcomes for that iteration number to be 'f'. So the above would now look like this:

       

      [Iteration Number]       [Outcome]         [Hit]

       

      5                                      f                    3      
                                               f                    3

                                              f                    3

       

      6                                       f                    2

                                               f                    1

       

      Thanks.

       

       

                       

       

                         
                        

        1 2 Previous Next