6 Replies Latest reply on Jun 9, 2017 5:12 PM by Zhouyi Zhang

    Calc field - plot bar chart

    Vishal D

      I have a 'Duration in hours' integer field for each store, year and month.

       

      I want to plot 2 bars '+ve' & '-ve' yearly

       

      +ve = SUM(Duration in hours) only for records where Duration > 0

      -ve = SUM(Duration in hours) only for records where Duration < 0

       

      How do I write this calculations and plot it?