4 Replies Latest reply on Sep 3, 2018 8:55 PM by Gavin Wong

    Using First ()

    Gavin Wong

      Hi guys,


      saw some examples from zen masters that they use First () to represent the 1st value in a chart on another axis.

      i attempted it and obviously it didnt work.

      as attached, the other dots appear at the bottom of the chart.

      what went wrong ?


      the calculated field i used was


      IF FIRST()=0 THEN SUM([Sales])