topic Re: bar chart to display percentile in App Development

bar chart to display percentile

nvijay5757 — Wed, 31 Aug 2022 10:37:28 GMT

Hi,

Row LabelsAverage of Average Speed Grand Total46.29787234

VIN1	43.38888889
VIN2	44.86363636
VIN3	41.32727273
VIN4	46.39622642
VIN5	48.76712329
VIN6	48.3902439
VIN7	46.30769231

for this will display as Histogram of frequency and percentile.

can anyone help me.

or in bar chart will display as histogram x-axis: average speed

y-axis percentile of vins frequency.

thanks.

Re: bar chart to display percentile

SunilChauhan — Wed, 31 Aug 2022 13:55:04 GMT

POC:
LOAD
[VIN_ID] & [Average Speed] AS Key,
Sn.No,
VIN_ID,
Trip_ID,
"Average Speed"

FROM [lib://test/Dummy_Data_HWD.xlsx]
(ooxml, embedded labels, table is Dummy_Data);

LEFT JOIN (POC)
Load *,
Fractile([Average Speed],0.50) as Percentile;
LOAD
Key,
Avg([Average Speed]) AS [Average Speed]
Resident POC
Group By Key;

and in Bar Expression

Count(distinct if([Average Speed] <= Percentile,0.50),VIN_ID))

Re: bar chart to display percentile

nvijay5757 — Wed, 31 Aug 2022 14:14:51 GMT

Hi Thanks for your reply,

can you please check in above script invalid expression. and below bar expression also some error.

Re: bar chart to display percentile

SunilChauhan — Wed, 31 Aug 2022 14:18:50 GMT

Share Excel which you loading here

Re: bar chart to display percentile

nvijay5757 — Wed, 31 Aug 2022 14:29:14 GMT

Hi please find the attached file.

ignore my above expression.

requirement is to display

x-axis: average speed

y-axis percentile of vins frequency.

Thanks.

Re: bar chart to display percentile

SunilChauhan — Wed, 31 Aug 2022 14:43:44 GMT

ignore above suggestion

please try below

Create a Variable in Variable overview i.e on GUI

vPercentile=Fractile([Average Speed],0.50) and the try below

Count(distinct if([Average Speed] <=$(vPercentile),VIN_ID))

Re: bar chart to display percentile

nvijay5757 — Wed, 31 Aug 2022 15:05:30 GMT

Hi,

Thanks its working.

actually my thought is to create variable for user enter percentile.

in this case we have taken variable as vPercentile. so how can i take for that user enter percentile.

ex: Enter Percentile:

Re: bar chart to display percentile

SunilChauhan — Wed, 31 Aug 2022 15:12:16 GMT

Take one input box and select variable .

Now you can change by entering values in input box .

And it will assign to variable and chart will change according to that.