# Box Plot Creation Issue

**URL:** <https://community.amazonquick.com/t/box-plot-creation-issue/20148>\
**Category:** Q&A\
**Tags:** dashboard, dashboards, formulas, visuals, calculations, Business-Intelligence-Engineer, quick-sight\
**Created:** [October 18, 2023, 5:10pm UTC](https://community.amazonquick.com/t/box-plot-creation-issue/20148 "2023-10-18T17:10:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![yipk](https://avatars.discourse-cdn.com/v4/letter/y/439d5e/32.png) [@yipk](https://community.amazonquick.com/u/yipk)\
**Post date:** [October 18, 2023, 5:10pm UTC](https://community.amazonquick.com/t/box-plot-creation-issue/20148/1 "2023-10-18T17:10:13Z")

</div>

Hi all,

I was wondering if Quick Sight had the ability to create a box plot on Quick Sight that would allow me to Group By an MHE cluster, and then have the individual quartiles labeled as the avg TPH value for a sort center. This is a screenshot I took from Tableau, and I would like to recreate it on Quick Sight.

 ![image (1)](https://d1wl4jav5dp96l.cloudfront.net/original/2X/b/bf1d789e79237535a8d5971665dd870ccfcfcd2c.png)

I’ve tried creating a calculated field to calculate TPH grouped by SC, but when I try to add that to the visual, I get an error. In the field wells, I have “benchmark\_type” under the Group By section and Avg TPH by Sort Center for the Value section.

---

<div class="post-metadata">

**Author:** ![yipk](https://avatars.discourse-cdn.com/v4/letter/y/439d5e/32.png) [@yipk](https://community.amazonquick.com/u/yipk)\
**Post date:** [October 18, 2023, 6:43pm UTC](https://community.amazonquick.com/t/box-plot-creation-issue/20148/2 "2023-10-18T18:43:39Z")

</div>

Here is the query that I used to pull the data into Quick Sight for reference, with the table names and filtering omitted for confidentiality purposes:

```auto
SELECT
a.date
, a.sc
, b.benchmark_type
, SUM(a.volume) / NULLIF(SUM(a.hours),0) as tph_nsnc_adjusted
FROM table1 a
LEFT JOIN table2 b ON a.sc = b.sc
WHERE a.category = 'insert_filter_here'
GROUP BY 1, 2, 3

```

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [November 14, 2023, 11:32am UTC](https://community.amazonquick.com/t/box-plot-creation-issue/20148/3 "2023-11-14T11:32:29Z")

</div>

Hi @yipk,  
did you found a solution?  
BR

---

<div class="post-metadata">

**Author:** ![yipk](https://avatars.discourse-cdn.com/v4/letter/y/439d5e/32.png) [@yipk](https://community.amazonquick.com/u/yipk)\
**Post date:** [November 14, 2023, 5:07pm UTC](https://community.amazonquick.com/t/box-plot-creation-issue/20148/4 "2023-11-14T17:07:37Z")

</div>

Hi @ErikG , after contacting Quick Sight SDE team about this, it appears that it is a Quick Sight limitation of not being to select the granularity of data for box plot visualizations. I have since had to do a workaround of using multiple queries to get the desired views I needed.

I have submitted a feature request for this.

Thank you for your help!