Calculation from Sheet with shuttled Data to combined data


I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various time periods. It would be great if I could color code them for different time ranges. Similar to this chart. Is that possible? I already have the formula to count days as a column formula in the original sheet.

Best Answer