6 Replies Latest reply: Jun 22, 2011 7:36 AM by Anne Duffy RSS

    Missing data between 2 charts Puzzle

      Hi Guys

       

      I have 2 tree maps,

       

      One is based on the demensions   Activity = 'Customer Service'

                                                        Type of Query

       

                                            Expression is [Type of Query ] = calculation is if(Activity='Customer Service',sum(Number))

      This works perfectly,

       

       

       

      The 2nd Tree map was Cloned from this one and basically it is looking at cycle times,

      Demensions are the same,

                based on the demensions   Activity = 'Customer Service'

                                                        Type of Query

       

      Expression is [Time to complete ] = calculation is if(Activity='Customer Service',sum(Number)*[Time to complete])/60

       

      This also works perfectly, at least it was , I have noticed that one activity in particular is not reporting correctly, on the first Chart it is numerical value of 13,610 ( which is correct) I would expect to see it on the second chart with a value of 58, its is not.

       

      Now in saying that this QV doc is pulled from numerous Excel sheets and this particular field is only common the 3 particular Areas, once I drill into those areas on the list box function the correct data comes up. But without the drill down it is not calculated as part of the total.

       

      Can anyone help ?

       

      Thanks

       

      A

       

       

      I only have a personal edition QV license so not sure I can post a sample