13 Replies Latest reply on Oct 30, 2013 1:53 PM by Adam Robins

    incorrect average reference line on "binned" field

    Adam Robins

      I am plotting the amount collected on loans (as a percentage of amount due) vs. the number of loans.  I've created a calculated field to act a a "bin" field, so I can have the y-axis range from 0 to 1 in increments of 0.01 for the collected percentage.  I then move the "bin" field from measure to dimension and made it a continuous field.  The graph displays as expected, however, when I add a reference line for "average", it does not display the correct result.  I'm sure I'm doing something incorrectly, but I can't seem to put my finger on it.  Any assistance would be appreciated.  Sample workbook attached, also an Excel file showing the raw data and "expected" average.  Thanks.