[Fabian Heil]

I´m currently struggeling with how to store data correctly to show it in a line chart.
My app is about work time bookings and holiday and i am storing the following data in a SharePoint list

• Day
• Time Balance (day) – e.g. +2h or -8h (absence)

I dont want to store the calculated total time balance in every time booking, as the order of bookings is not always the same and e.g. canceling a booking would affect all items in the future.

Example: 

I only have the value “Day” and “Time Balance (Day)” in SharePoint.
Can i work with calculated values (Time Balance Total) in a line chart without having the cumulated value for every day in the sharepoint list?

Hope, you understand my issue 🙂

——————————
Fabian Heil
——————————

[Brian Scott]

You can just save the data you have in the screenshot as a Collection and use the Collection to drive the chart

——————————
Brian Scott
Chief Creative Officer
Concord NC
——————————
——————————————-