I've been asked to create a bar chart for a hypercare log like the one shown in the attached screenshot. The ask is to have a stacked bar for each week showing how many cases were active in a given week and how many were of each status (New / In Progress / Resolved / Escalated). The ultimate goal is to see the trend of how many cases were handled each week, with the hope of seeing the number decrease week-by-week.
All I have been able to find is how to make a single bar, for the current week. Have I been asked to do something outside Smartsheet's capabilities?
Example of the formula used for Summary Field "New Cases - Current Week":
=COUNTIFS(Status:Status, "New", WeekNumber:WeekNumber, WEEKNUMBER(TODAY()))
