Stacked bar chart by time interval

[#1]

Hi,

I need to create a stacked bar chart  that shows me the Total of a value for a specific time intervals (e.g. 30-60 days; 60-90 days; 90-180 days) with an agregation by another dimension.

Considering the sample data in attach, the objective is to have the sum of column Value for the time intervals that I mentioned above grouped by column Level.

Example of time periods:

≤ 30 days

30 days < …  ≤ 90 days

> 90 days

Please look to the attached image that gives an idea of what I looking for.

Anyone could help me?

Thanks in advance

Paulo

[sinanozdemir]

Hi,

I tried to use your sample data and it seemed like day differences didn't go beyond 21 days.

I am attaching the sample app and hope it helps you.

Thanks