# Charts : Numeric data not displayed as intended **URL:** \ **Category:** Ask for Help\ **Created:** [August 15, 2023, 3:28pm UTC](https://community.glideapps.com/t/charts-numeric-data-not-displayed-as-intended/65048 "2023-08-15T15:28:13Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![smallpond](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smallpond/32/61256_2.png) [@smallpond](https://community.glideapps.com/u/smallpond)\ **Post date:** [August 15, 2023, 3:28pm UTC](https://community.glideapps.com/t/charts-numeric-data-not-displayed-as-intended/65048/1 "2023-08-15T15:28:13Z")
**What I’m trying to do…** To create two charts to show the following data: 1. Total Item Count by Date: This chart should illustrate the cumulative count of items as they are added up each day. 2. Total Amount by Date: This one should display the cumulative total amount as they are added up each day. **Problem** As you can see in the charts below, the numerical values on the charts don’t align with the corresponding data in the table. Have I overlooked any details? ![TEST_charts](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0d995285905c790dfb79c7297faeed3270746015.png) ![Table_TEST](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/c/6c502b98b6556cafe258eb2c39eba8f5ee304cc7.png) **Additional Question** For data aggregation, I utilized Query and Rollup columns. Is there a more straightforward method to yield the same results? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 15, 2023, 3:39pm UTC](https://community.glideapps.com/t/charts-numeric-data-not-displayed-as-intended/65048/2 "2023-08-15T15:39:42Z")
Based on what you are selecting and how you have it set up, it looks correct. 1/1 Total of Total\_ItemCount is 1 1/2 Total of Total\_ItemCount is 6 (3+3) 1/5 Total of Total\_ItemCount is 21 (7+7+7) Likewise for Total Amount 1/5 Total of Total\_Amount is 69 (23+23+23) ---
**Author:** ![smallpond](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smallpond/32/61256_2.png) [@smallpond](https://community.glideapps.com/u/smallpond)\ **Post date:** [August 15, 2023, 3:46pm UTC](https://community.glideapps.com/t/charts-numeric-data-not-displayed-as-intended/65048/3 "2023-08-15T15:46:54Z")
@Jeff_Hager Thanks for your quick reply! Ah, I see what you mean… How can I accomplish what I want to do - to show only one total data for each day without adding them up if there are multiple entries per day? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 15, 2023, 4:15pm UTC](https://community.glideapps.com/t/charts-numeric-data-not-displayed-as-intended/65048/4 "2023-08-15T16:15:30Z")
I’m not sure how your Rollup and Relation columns are configured, but does it make sense to you that the rollup and relation repeat everything multiple times for each unique day? You need to either da way to filter your data so only one row per day is read, or create a list of unique dates that aren’t repeated, or do some with your Relation and Rollups so they only retrieve information that is relative to the row. Maybe the Item and Amount columns play a role here? ---
**Author:** ![smallpond](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smallpond/32/61256_2.png) [@smallpond](https://community.glideapps.com/u/smallpond)\ **Post date:** [August 23, 2023, 5:54am UTC](https://community.glideapps.com/t/charts-numeric-data-not-displayed-as-intended/65048/5 "2023-08-23T05:54:58Z")
Hi, @Jeff_Hager, I figured it out by adding more computed columns and filtering the data based on your suggestion. Thanks! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [August 30, 2023, 5:55am UTC](https://community.glideapps.com/t/charts-numeric-data-not-displayed-as-intended/65048/6 "2023-08-30T05:55:09Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.