creating a time series dashboard
I have several data sets with data similar to the table above. I would like to create a graph such that on the x-axis would be time in weeks and y -axis would contain the total (22%) similar to the graph below:
I suspect that I would need to consolidate this data onto a sheet. How would setup the sheet to pull the % data for each Friday of the year?