1 Reply Latest reply on Jul 24, 2018 2:15 PM by Patrick A Van Der Hyde

    How to exclude dimension at visualization for % calculation in sheet level from secondary source datablending.

    srikanth t

      Please suggest :

      Requirement to Calculate %

       

      formula :

      COUNTD([Award Receiver]) / avg([HC (My Moment Data V3)].[HC])

       

      here COUNTD([Award Receiver]) field from primary data source

           avg([HC (My Moment Data V3)].[HC]) from secondary data source

       

      to get same colors manager related I have used mgr-3 field in color in the awards by leaders level -1 & 2 chart .. which gives the visualization as leaders as per relevant manager colors. Screenshot 1 & 2 provided below . I want to exclude that dimension in calculating %..the above % Calculation formula is working when I remove MGR-3 field from the color in marks screenshot -3 provided below ..if I use mgr-3 field in color in marks--not getting the percentages. For bars

       

       

      screenshot 1

       

      screenshot 2

       

       

       

      screenshot 3

      the above % Calculation formula is working when I remove MGR-3 field from the color in marks. Screen shot.. for your reference

       

       

      Regards,

      S