Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies