7 Replies Latest reply on Sep 7, 2018 3:11 PM by JJ Baisch

    Bar Graph changed to Line Graph changes the values to be incorrect

    Ashley Dettlaff

      Columns: Year, Month, Day

      Row: Percent Plan



      When I add "percent plan" as a bar graph the percentages are correct (85-100% range)


      When I change the type to a line, the percentages change to fall between 10-20% which is incorrect.


      Percent plan is a calculation of:    (Running Sum (Daily Volume))/(Running Sum (Planned Volume)) *100



      I read another discussion of the same problem, and it was solved by changing the dates to ATTR in the details shelf but this did not work in my case