0 Replies Latest reply: Jan 15, 2018 4:08 AM by Bartlomiej Gulej RSS

    Treemap - coloring by measure, display percentage

    Bartlomiej Gulej



      I have a problem regarding Treemap and proper display percentage value in tooltip.

      Treemap is configured as follows:


      Dimension is Brand

      Measure is Margin (value)


      And there is coloring set "by measure" where I've changed default measure from Margin (value) to another (from Master Items) - Margin (percentage). It works, but the value is displayed without formatting: 0,0525 instead of 5,25%. I can't make that work.


      Margin (percentage) is defined as =$(vMarginPerc) while this variable is set during loading script as follows:


      LET vMarginPerc= 'num(sum([MarginValue])/sum([SaleValue]), ' & chr(39) & '# ##0,00%' & chr(39) & ')';


      Wherever I'm displaying Margin (percentage) with formating set to "auto" it displayes correctly (f.e. KPI's, bar charts, etc) - only in Treemap as color by measure it doesn't want behave as I want...


      Any ideas?