Calculation from Sheet with shuttled Data to combined data

Jenifer J.

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.

Gia Thinh

Hi @Jenifer J.

Yes. it is posible for you to create a Stacked Column chart on your dashboard as the screenshot below. You may need to add more columns to your sheet for calculating different time ranges.