# QuickSight Bar Chart Double-Counting Planned Hours Per Issue **URL:** \ **Category:** Q&A\ **Tags:** calculations, Business-Intelligence-Engineer, quick-sight\ **Created:** [November 14, 2025, 8:34pm UTC](https://community.amazonquick.com/t/quicksight-bar-chart-double-counting-planned-hours-per-issue/50553 "2025-11-14T20:34:23Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![sree](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sree](https://community.amazonquick.com/u/sree)\ **Post date:** [November 14, 2025, 8:34pm UTC](https://community.amazonquick.com/t/quicksight-bar-chart-double-counting-planned-hours-per-issue/50553/1 "2025-11-14T20:34:23Z")
Sample Dataset | project\_name | project\_key | issue\_key | start\_week | end\_week | author | planned\_hours | | --- | --- | --- | --- | --- | --- | --- | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-40 | 2025-10-27 | 2025-11-02 | user 1 | 10 | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-40 | 2025-09-01 | 2025-09-07 | user2 | 10 | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-40 | 2025-09-01 | 2025-09-07 | user1 | 10 | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-40 | 2025-09-15 | 2025-09-21 | user3 | 10 | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-40 | 2025-09-22 | 2025-09-28 | user4 | 10 | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-40 | 2025-10-06 | 2025-10-12 | user4 | 10 | On my dashboard, I have **global filters** for **project\_key** , **author** , and **week duration**. I have a **bar chart** that is supposed to show **planned hours per project** based on the selected filters. For example, if I set the week filter from **2025-10-06 through 2025-11-02** , QuickSight returns these two rows: | project\_name | project\_key | issue\_key | start\_week | end\_week | author | planned\_hours | | --- | --- | --- | --- | --- | --- | --- | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-40 | 2025-10-27 | 2025-11-02 | user1 | 10 | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-40 | 2025-10-06 | 2025-10-12 | user4 | 10 | Since it is the **same project and same issue** , I expect the bar chart to show **10 hours** , not 20. The issue is that **planned\_hours is the same across rows for the same issue\_key** , so QuickSight **sums both rows**. I tried using a **calculated field with `maxOver`** , but it still shows 20 instead of 10. Has anyone encountered this problem or have suggestions on how to **prevent double-counting planned hours per issue** in a QuickSight bar chart when filters are applied? ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [November 14, 2025, 9:23pm UTC](https://community.amazonquick.com/t/quicksight-bar-chart-double-counting-planned-hours-per-issue/50553/2 "2025-11-14T21:23:03Z")
Hi @sree, What’s the calculation(s) you’re using in your bar chart? Could you share a screenshot of how you have it setup and what fields you’re using for each axis? Could you also share the maxOver calculation that you built so that we can see why it was producing 20 instead of 10? ---
**Author:** ![sree](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sree](https://community.amazonquick.com/u/sree)\ **Post date:** [November 15, 2025, 12:16am UTC](https://community.amazonquick.com/t/quicksight-bar-chart-double-counting-planned-hours-per-issue/50553/3 "2025-11-15T00:16:36Z")
I tried different things. example dataset - | Column 1 | Column 2 | Column 3 | Column 4 | E | F | G | H | I | J | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | project\_name | project\_key | issue\_key | start\_week | end\_week | actual\_hours | author | planned\_hours\_week\_level | remaining\_hours\_issue\_level | My comments | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-31 | 2025-10-13 | 2025-10-19 | 0.5 | Seppe Vercauteren | 20 | 0 | | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-40 | 2025-10-27 | 2025-11-02 | 0.33 | Jofry Van de Walle | 10 | 0 | | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-40 | 2025-10-06 | 2025-10-12 | 2 | Herman Goossens | 10 | 0 | should be counted only once | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-43 | 2025-10-06 | 2025-10-12 | 1 | Kevin Brems | 20 | 0 | | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-44 | 2025-10-13 | 2025-10-19 | 0.17 | Kevin Brems | 20 | 19.833333333333332 | | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-45 | 2025-10-27 | 2025-11-02 | 0.33 | Jofry Van de Walle | 10 | 0 | | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-51 | 2025-10-06 | 2025-10-12 | 0.25 | Kevin Brems | 0 | 0 | | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-53 | 2025-10-06 | 2025-10-12 | 0.25 | Kevin Brems | 0 | 0 | | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-63 | 2025-10-06 | 2025-10-12 | 0.17 | Rita Raman | 0.5 | 0 | | | DCH-0087758 - URL 58\_IAG1\_LH | URL58 | URL58-64 | 2025-10-06 | 2025-10-12 | 0.17 | Rita Raman | 0.5 | 0 | | | | | | | | | | | | | | | | | | | | | 91 | | � | Quicksight Calculation - Total Planned Hours = maxOver({planned\_hours\_week\_level}, [{issue\_key}], PRE\_AGG) Stacked Bar Combo Chart - X-Axis = Project Key Bars = Quicksight calculation - SUM(Total Planned Hours). shows as 91 whereas it should be 81. ---
**Author:** ![sree](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sree](https://community.amazonquick.com/u/sree)\ **Post date:** [November 15, 2025, 1:04am UTC](https://community.amazonquick.com/t/quicksight-bar-chart-double-counting-planned-hours-per-issue/50553/4 "2025-11-15T01:04:49Z")
I figured out the calculated field and now i am getting the right result. calculated field - Total Planned Hours = sum( max({planned\_hours\_week\_level}, [{issue\_key}]) )