3 Replies Latest reply on May 18, 2016 9:55 AM by Yuriy Fal

    Calculated Fields with Bins Intervals

    André Coelho

      Hi everyone!


      I'm trying to show in my workbook the % of sales for different [Obra] in different period of time (6 months). For each period of time I want to visualize one line that shows the goal for that period.

      Eg: For period 0 the goal is 40%; for period 6 the goal is 50%.


      I created a calculated field [Semester] and created Bins based on this field but it didn't work.


      The [Data] dimension goes over 2015 and 2016.

      [Vl Recbt] measure = total of sales/ month


      I've attached the workbook and the data source here.


      Could anyone help me?