topic Percentile in Bar chart in App Development

Percentile in Bar chart

nvijay5757 — Fri, 02 Sep 2022 02:42:19 GMT

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.

Re: Percentile in Bar chart

SunilChauhan — Fri, 02 Sep 2022 07:37:58 GMT

. 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

Re: Percentile in Bar chart

nvijay5757 — Fri, 02 Sep 2022 09:24:01 GMT

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.