cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
elijah2018 Regular Visitor
Regular Visitor

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

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-jiascu-msft Super Contributor
Super Contributor

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

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-jiascu-msft Super Contributor
Super Contributor

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

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

elijah2018 Regular Visitor
Regular Visitor

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

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. 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 165 members 1,651 guests
Please welcome our newest community members: