need help with (grid-?) chart

[#1]

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.

[tresesco · Accepted solution]

In the calculated dimension, you have to use Aggr() alongwith any aggregation function. Hence, try like:

Aggr(sum(accepted), Dim1) /Aggr(count(id), Dim1)

[avinashelite]

sum(accepted)/count(id) this the error for the "Error in calculated dimension" we cannot use this kind of calculation in dimension unless it will calculate using AGGR fundtion.

Try like aggr(sum(accepted)/count(id),calculation_on_dimension_required)

if you share the exact requirement we can help you 

[#4]

Hi the both of you!

Your help really pointed me to the result I was looking for.

Thanks a lot for your help!!!!

[avinashelite]

mark the helpful and correct answers

[#6]

Hi again,

I would like to add a question to the upper part.

The scale for the y-axis is in percent but it is always autoscaling (e.g. max val is 60% so it ends with 60%).

Within the properties --> axes setting I can not edit the "static max" value.

Does anyone know how I can change it so that the y-axis is always showing 100%?

Thanks and regards