2 Replies Latest reply on Mar 24, 2016 6:32 AM by pooja.gandhi

    Show count result without adding dimension to details shelf.

    Carlos Albuquerque

      My current issue is that I have an LOD calculation that calculates if an ID is true or false, and I am unable to display a bar that contains the total result without having the bar breakdown in multiple ids that are stacked.

      I know I can remove the ID from the color shelf and make it look like one bar, but if the user wants to investigate the underlying data, they are unable to do it for all ids that fall into one bucket (yes or no), since there are individual marks on the shelf.

       

      LOD USED:
      {FIXED [ID]: IF [measure] > 0 then 'yes' else 'no' }

       

       

      If i remove the id's from the detail shelf, this is the result i get, which is wrong because it evaluates all ids instead of one by one.