What I’m trying to do…
To create two charts to show the following data:
Total Item Count by Date: This chart should illustrate the cumulative count of items as they are added up each day.
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?
@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?
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?