4 Replies Latest reply on Oct 30, 2013 6:23 AM by maheswar.vayugandla

    Issue with displaying additional data on selecting Slice in the PIE chart

    maheswar.vayugandla

      Hi,


      I am having an issue with displaying desired information upon clicking the slice in the PIE chart. I have the data in the below mentioned format for 4 teams and their rating across several projects on monthly basis.

       

      I have a Dashboard displaying PIE charts (with counts of Rating) for each team on the left and then displaying detailed information on the right upon clicking the corresponding slice.

       

      I am using 'Team Name' as the 'Columns' attribute in the detailed report and so it is displaying all the teams in separate columns automatically. The issue I am having  is that when I click on the PIE slice (I have set the filter for PIE charts and Detailed View) , it is displaying only the corresponding Team column with related Rating records. But I would like to see the other Team columns also to compare against the selected team.

       

      I understand this is the behavior as per the data because 'Team Name' is a column with set of Team names and the filter being applied on the Team name is preventing from displaying other teams information.

       

      How to resolve this issue without changing the data format ?

       

      I am also attaching the packaged project. Thanks.

       

      Effective DateProjectTeam NameTeam Rating
      10/1/2013KXTBRTeam11
      10/1/2013KXTBRTeam22
      10/1/2013KXTBRTeam32
      10/1/2013ACBTRTeam41
      10/1/2013ACBTRTeam11
      10/1/2013ACBTRTeam23
      10/1/2013ACBTRTeam33
      9/1/2013ACBTRTeam43
      10/1/2013GXYIOTeam12
      10/1/2013GXYIOTeam23
      10/1/2013GXYIOTeam33
      8/1/2013ACBTRTeam43