exclude the outlier in histogram

[Anonymous]

Hi,

wondering I create a histogram. the average price is around 20-100 but have one outlier (bad datapoint) about 4000

is that any easy way (only use dashboard) to exclude it  then can make the histogram more pretty (in right scare)

Any suggesting methord to solve this without change underline data (loading data)

Thank you!

[Anonymous]

I try to use

=if(prise<(max(prise)-1),prise)

in the data selection field but does not work. any suggestion? Thank you!

[sunny_talwar]

Since, this is a histogram, you won't be able to perform any calculation in the this particular chart. You have two options

1) Create a bar chart with your own buckets

2) Modify the script to create a new price field which already exclude the outliers. something like this

Table:

LOAD ...,

     price

FROM ....;

Left Join (Table)

LOAD Stdev(price) as StdevPrice,

     Avg(price) as AvgPrice

Resident Table;

FinalTable:

LOAD *,

     If(price > AvgPrice - 3*StdevPrice and price < AvgPrice + 3*StdevPrice, price) as new_price

Resident Table;

DROP Table Table;

[Anonymous]

I add a description in the data load editor

saying

where [prise]<4000

as hard coding this time. ---then I will change all the graph

but is there any way, I do not change loading data, but only use if() function to limited the data rang for the specific graph on dashboard? at the Data- Fields--prise--Field.

or should I create a variable in the dataset excluding this number (which may mean, if n>4000 then change it to 0)?

Thank you!

[sunny_talwar]

Use bar chart instead of histogram and you will be able to use the if statement