Hello Glide Community,
First to explain my data
I have multiple partners who have wifi units (access points) and want to see how much data they use per day. They can have multiple access points and at multiple locations, which are all linked to the user.
I have a “Ledger” Sheet that shows the following
Date | Owner | Location | Access Point | GB Data
When I try to show this on the glide bar chart It shows the date correctly on the X axis but they Y axis just shows a count of how many items are in that sheet for that day for that user (if 3 access points passed data it shows 3)
I need it to sum the total data for that user that day. For examples if they had 3 access points and they passed 2.1 GB, 1 GB, 2 GB, the chart should show 5.1GB data passed that day on the chart
Thanks!