
1. Re: Total # of records used in boxandwhisker plot?
Chris McClellan Dec 21, 2018 1:52 PM (in response to Zach Anderson)Any chance you can supply a sample workbook please ?

2. Re: Total # of records used in boxandwhisker plot?
Zach Anderson Dec 23, 2018 10:19 AM (in response to Chris McClellan)Updated the post and added an example workbook, thanks

3. Re: Total # of records used in boxandwhisker plot?
Chris McClellan Dec 23, 2018 2:38 PM (in response to Zach Anderson)1 of 1 people found this helpfulThe easy answer is that the box & whisker is DISaggregated data, so you will only get 1 in your calculations.
The line graph works because it's AGGregrated data, so you get the right numbers.
If you're creating a dashboard, it will be a lot easier to create another sheet just to show the number of records you're displaying. Trying to put everything on the same sheet is tricky (I tried a few tricks and couldn't get it to work!)

4. Re: Total # of records used in boxandwhisker plot?
Mavis Liu Dec 24, 2018 3:53 PM (in response to Zach Anderson)1 of 1 people found this helpfulHi Zach,
Please update your Total Record count table calc to select all the fields:
Thanks and please see the attached workbook.
Thanks,
Mavis

5. Re: Total # of records used in boxandwhisker plot?
Zach Anderson Dec 27, 2018 7:24 AM (in response to Zach Anderson)Mavis Liu's solution was exactly what I was looking for!
I did end up also using Chris McClellan's solution, as it provided an elegant means of displaying this number on Dashboards.
Thanks!