5 Replies Latest reply: Sep 15, 2015 10:35 AM by Riewert Hinrichs RSS

    need help with (grid-?) chart

      Hi there,

       

      I was asked to create a (grid-?) chart with the following dimensions:

       

      x-axis:

      - price range [0-50, 51-100, 101-150, 151-200 for example]

      y-axis:

      - some kind of ratio (0-100%)

       

      All that in the relation to a total number.

       

      Here is an example:

       

      The data table is roughly:

      - id (int)

      - range (text)

      - accepted (bool)

       

      If I have the two dimensions "range" and the calculated dimension "sum(accepted)/count(id)" I always get an "error in calculated dimension".

       

      Does anyone know how to solve that problem?

      Any help is appreciated.