7 Replies Latest reply: May 26, 2011 5:01 PM by kakarottoo RSS

    Set Analysis Doubt

      Hi,

         We have a chart displaying time duration for a drilldown(Customer,division etc) over a no of steps. Now when a particular division is selected and a step is selected, we want to see the duration for all other divisions for the particular step. Can this be done using Set Analysis.

       

      I tried Avg({$<step={'*'}>}{1-$}duration). It shows the result for all other divisions but it remains the same for any step i choose. Anyone having any ideas. Thank you.

        • Re: Set Analysis Doubt
          John Witherspoon

          Maybe this?

           

          avg({<division=E()>} duration)

            • Re: Set Analysis Doubt

              Thanks. But it is still the same. Maybe making two selections is affecting the set Analysis

                • Re: Set Analysis Doubt
                  John Witherspoon

                  avg({<Division=E()>} total Duration)

                   

                  That seems to work in the attached example.  If that's not what you meant, I'll need further explanation, preferably in the form of modifying the example to demonstrate both the problem you're having and the result you expect.

                    • Re: Set Analysis Doubt

                      In this example when i choose B, it shows only B values. What We want to see is when B is selected, we want to see data for everything except B(In this case A). So i tried using {1-$} before the total duration, but it doesn't work. The value remains same for all the steps.

                        • Re: Set Analysis Doubt
                          John Witherspoon

                          See the attached example.  I've added Division C.

                           

                          Now, if you select division B, step 1, the FIRST chart (which was the first expression I gave you), shows instead divisions A and C, and the average duration for each for step 1.  That's what I initially thought you wanted.

                           

                          But you didn't like that answer, so I guessed that maybe you instead wanted an overall average of A and C's step 1 on the same line as division B.  That's the second expression, shown in the second chart.

                           

                          If you don't want to see A and C's data separately, and you don't want to see it with B, then where DO you want to see it? 

                           

                          Or... you mention the value remaining the same for all the steps.  In your initial explanation, you said you were selecting a specific step ("and a step is selected").  Is that NOT the case now?  So you want to NOT select a step, JUST a division, and see the average for A and C associated with the step on the line in the chart?  In that case, this seems to work:

                           

                          aggr(nodistinct avg({<Division=E()>} Duration),Step)

                           

                          Right or wrong, I'm done playing guessing games.  I won't be replying to this thread again.

                  • Re: Set Analysis Doubt

                    It seems to be working now. What would we do if we need to include a cyclic group(division is a part of cyclic group)?