Percentile in Bar chart

[nvijay5757]

Hi,

i have the data like, VINs and [Ambient temperature], to display data in bar chart like 

x- axis : Ambient temperature

y-axis : No.of vins for ambient temperature. within the range no.of vins(and also to apply percentile)

user to enter percentile.

i am facing probelm for y-axis value help me thanks.

the above bar like and will apply percentile.

[SunilChauhan]

. I have used Inline table but Use Below concept using you Excel

Test:
Load VIN,
AVG([Average Of ambient Temp]) as NewAVG
group by VIN;

Load * inline [
VIN,Average Of ambient Temp
VIN1,45.88888869
VIN2,61.63636364
VIN3,48.09090909
VIN4,46.41509434
VIN5,50.95890411
VIN6,50.14634146
VIN7,44.46153846
];

Create a Variable and take in "Variable Input" from Custom Objects

[nvijay5757]

Hi,

Thanks for your reply.

Bar  chart the requirement is calculate for a particular percentile the distribution of VIN count. 

please find the test data.

ex: 90 percentile distribution of Temp we need to count the VIN

for example Temp range 80-90, total VIN=7 are in this range for 90 Percentile Temp. 

                          Temp range 70-80, total VIN=5 are  in this range for 80 Percentile Temp. 

we want to plot this type of bar chart.