Forum Discussion
Creating a Histogram Decile Chart
Hi all, I'm trying to create a histogram that shows the count of properties by decile group. The raw data I have looks like this:
| Property ID | Rent | Local Comparator |
| Property 1 | £82.50 | £100.00 |
| Property 2 | £90.00 | £100.00 |
| Property 3 | £117.50 | £100.00 |
| Property 4 | £98.50 | £100.00 |
| Property 5 | £126.50 | £100.00 |
I have a measure that divides the rent by the local comparator and, using the Ceiling function, rounds the result upwards to the next decile - for example:
| Property ID | Rent | Local Comparator | Decile |
| Property 1 | £82.50 | £100.00 | 90% |
| Property 2 | £90.00 | £100.00 | 90% |
| Property 3 | £117.50 | £100.00 | 120% |
| Property 4 | £98.50 | £100.00 | 100% |
| Property 5 | £126.50 | £100.00 | 130% |
When I put the information into a graph, the results look like this:
I would like the bars to show the count of properties by decile group, but cannot figure how to do this. Can anyone help?
5 Replies
Hi amitchandak , the decile calculations is a measure, not a column. I wanted to try to avoid using a column, as I need to build other comparators later which would add many columns to the model.
Did you select the 100% Stacked Chart (Y axis has % values)? If so, change it to a regular stacked or clustered chart.
Pat
Hi Pat, the example shows a regular chart.
Hi Saes ,
Try to use stacked column chart and it works fine
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
