Auto-Update Data Columns based on Index

[susigan]

Hi guys, i attach two samples worksheets i have

- "Form Sheet" , updated based on external data provided by appsheet
- - in "sheet4 " - at rows 4 to 10 i get data from "Form" , using INDEX to match the dates , but evertime i need to manually update the lasts columns of this rows (4:10) to get new data from "form"


i tryin figure out first by get a error create a pivot table, and i have many columns (one from eachday), so i still need add manually each day in this table.
Second i can just fillout until the end of columns , but this give me a error in my graph (lack of data)

[JeteMc]

I believe that the issue could be resolved by changing the power query advanced editor code at least for the series that you are charting. Most of the types are either "any type" or "text" and for the series that you want to chart it seems that they should be either "whole number" or "decimal". I can not illustrate this in the file as I do not have access to the source data.
On the form sheet is a chart based on the values in the power query produced table, with values changed using text to columns, to show you what it would look like.
Let us know if you have any questions.

[susigan]

Thanks the data is pulled from a Google sheets, i will try to change that.

But the major issue for now its how i pulled/auto update the data from " Form" to "Sheet4" E3:E10 the lasts columns , if i figured out may be i can do the the same to C50 and C52 (total score) , then to Rollinmg Average etc..
One pulled from another one.