2 Replies Latest reply on Oct 30, 2018 5:31 AM by P C

    Divide running sum by non-aggregate value

    P C

      My graph consists of plotting running sum (y) as a percentage of a non - aggregate number (x).

      The graph and the non - aggregate number have the same filters, however while -plotting it shows error of cannot mix aggregate with non-aggregate argument.

      If I divide it just by the sum of x, the dates for aggregate plot (y) and x are different, and it completely messes up the plot.

       

      I cannot fix the ( x ) as it is user controlled.

       

      The running total graph :

      ss1.png

       

      have to take it as a % of this : (which changes as the user selects different division)

      ss2.png