creating a time series dashboard

Martha Talenga

Hi

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?

jmyzk_cloudsmart_jp

Hi @Martha Talenga

If you have a date column in the row where the Total % is calculated, you can get the week number by the following formula:😀

=IF(ISDATE(Date@row), WEEKDAY(Date@row))

Since Friday is weekday number 6, you can use a report with a week number = six filter to get just the Friday data.

Below is a demo solution.

https://app.smartsheet.com/b/publish?EQBCT=e5718dc2827245809b57551038cbd06c