5 Replies Latest reply on Jun 28, 2018 7:40 AM by Ashley Dettlaff

    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