(jan pieters) box and whiskers automatically excludes rows containing the value 0

[elijah2018]

Hi everyone, 

I've tried to get the box and whiskers visualization to work like i need it to for a while now without luck.  I have data that is generated by a function that is dependent on stochastic variables and time with the possibility that the function value is 0 (zero).
I want to visualize the function value over the time span in my data and for each year I know I have 800 values that should be used for the box and whiskers visualization, but the method seems to exclude rows that includes the value 0 when it calculates the box/whiskers etc.

Any help will be much appritiated. 

Elijah

[v-jiascu-msft · Accepted solution]

Hi Elijah,

I tested it with Python. It seems the 0s should be considered. (I'm not the expert of Statistics). I would suggest you contact the author from here. 

Best Regards,

Dale

[elijah2018]

Thanks for your answer @v-jiascu-msft . 

I know the 0's should be considered and I was very suprised they where filtered out. 

Thank you for your answer.