0 Replies Latest reply: Jul 28, 2015 10:57 AM by raghu bharath RSS

    HOW TO IGNORE FIELDS IN EXPRESSION IN BAR CHART?

      HOW TO IGNORE FIELDS IN EXPRESSION IN BAR CHART?

      =if(getcurrentfield(GeoAreaRegionTerritory) = 'GEO_DISPLAY',

        Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[GEO_DISPLAY]> [Quadrant_Pos]),

        if(getcurrentfield(GeoAreaRegionTerritory) = 'AREA_DISPLAY',

        Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[AREA_DISPLAY]> [Quadrant_Pos]),

        if(getcurrentfield(GeoAreaRegionTerritory) = 'REGION_DISPLAY',

        Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[GEO_DISPLAY],[AREA_DISPLAY]> [Quadrant_Pos]),

       

        Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[GEO_DISPLAY],[AREA_DISPLAY],[REGION_DISPLAY]> [Quadrant_Pos]),

        )))

       

      • THIS IS THE EXPRESSION USED
      • THERE IS A DRILL DOWN GROUP =(GeoAreaRegionTerritory)
      • Quadrant_Pos= LEGENDS

      PIC1.PNG

      • in the below image when I click on Geo level, it goes to next level area and each area has it own 100% bar

      PIC2.PNG

      • but when I am clicking on 46%(red-NA) (i.e; any legend color), then it is showing me 100% , but the requirement is to get count of % of 46% in each area(i.e; NM/GW+PLAT+PS/CAN=46%/100%), how can we modify the expression to get this requirement.

      PIC3.PNGTHANKS IN ADVANCE