I’m having trouble working with a basketball stats datatable in Blueprint. Here’s what it looks like:
There are 4 rows that all apply to one game. What I’m trying to do is grab each team’s total for that game and then divide that by the number of games played (eventually) to give me a season average. I plan to do more than that, but I feel like I need some help unlocking my knowledge.
I know there are easier ways to do this. I want to do it in Blueprint if at all possible. If you think I’m betting off learning how to do this in excel or sheets, I’ll take that advice. I already have some experience in blueprints and I wanted the project to be a little more than just a spreadsheet.
Here is where I can’t figure out what to do next. I can get all the datatable rows. The only way I knew how to proceed was to do some funky converting and then I could get all of one specific column to display. I’m stuck on how to keep iterating through and pulling only the row/column combinations I’m looking for.
If I can get some help drilling through the datatable to get the parts I need, I believe I can take off with the rest. For example, choosing a teamid and at home and then giving me the season average. I can handle all the math, just can’t get to it.
Thanks for any help!