Help with how to correctly shape my data source

[Whoule]

Hello,

I am currently creating a dashbaord to demonstrate the following indicators from our day to day operations:

- Incoming Requests (Volume received)

- # of transactions completed

- # of transactions outstanding

I am having issues since my Volume and Completed columns are not cumulative while my outstanding column is. So when I am making a graph, it makes the sum of the volume and completed column which is good but it also sum up the outstanding column while the values in this column are already a sum...

I would like to optimise the structure of my datasource, here is what it look likes right now.

Date	Type	Volume (New)	Completed (New)	Outstanding
2021-04-15	Credit	500	0	500
2021-04-15	Financial Rejects	450	50	400
2021-04-15	Non-Financial Rejects	900	100	800
2021-04-15	GD Mailbox	15	10	5
2021-05-03	Credit	50	30	520
2021-05-03	Financial Rejects	50	100	350
2021-05-03	Non-Financial Rejects	100	200	700
2021-05-03	GD Mailbox	10	5	10
2021-05-17	Credit	50	100	470
2021-05-17	Financial Rejects	100	150	300
2021-05-17	Non-Financial Rejects	150	250	600
2021-05-17	GD Mailbox	2	2	10

Thank you very much in advance.

[V-pazhen-msft]

@Whoule 

Which chart are you using? can you explain with your chart? Normally you should add type to legend to distinguish.

Paul Zheng _ Community Support Team

[Whoule]

The issue is that I want to report on how much we completed vs the # of outstanding items as of a certain date. The data for my completed column seems fine in my chart since it sum up the values as of that date. The problem is that it also sum up my outstanding items from my data source...

[amitchandak]

@Whoule , can you share expected output