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 :



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