Power Apps Exchange

Please login or click SIGN UP FOR FREE to create your PowerAppsUG account to join this user group.
 View Only
  • 1.  LineChart with calculated data

    Posted Aug 16, 2021 08:20 AM
    Edited by Fabian Heil Aug 16, 2021 08:39 AM
    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
    ------------------------------


  • 2.  RE: LineChart with calculated data

    Top Contributor
    Posted Aug 17, 2021 07:10 AM
    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
    ------------------------------