10% fractile and accumulation

[yavoro]

Hi everybody,

I'm trying to create a chart that represents price differences distribution.Please see the attachment.

The problem I've got is the line in the graph doesn't cross the 10% reference line at the right point.

I think that should be the 10% fractile amount, which is -322.But the line crosses 10% at different value - about -200.

So am I wrong thinking cross point should match 10% fractile value?

Any ideas or suggestions are much appreciated.

Thanks

[swuehl · Accepted solution]

I think the problem arise because in your line chart you use buckets classified by the avg(DIFF) per ID, while your fractile is based on the raw records. If you use

='10% fractile is: ' & fractile(aggr(avg(If(DIFF<>0,DIFF)),ID),0.1)

instead, you get something like -218, which is pretty close to what you see in your chart.

Hope I have understood your setting correctly, though.

Regards,

Stefan

[yavoro]

Thanks Stefan,

You opened my eyes to see the inconsistency in the two calculations.

Actually the fractile number was all right and I had to amend the chart dimension to achieve what I wanted – didn’t need the aggregation there.

Regards

Y