Group Data to get a Filling Level over Time

[Anonymous]

Hi Qlik-Community,

I have a table (GanntTable) that contains an ID, a Type and EntryTimestamp, ExitTimestamp. I use this table to display a Gannt Chart.

GanntTable:

ID	Type	EntryTimestamp	ExitTimestamp
A	Area1	01/01/2018 10:00:00	01/01/2018 15:00:00
A	Area2	01/01/2018 15:00:00	01/01/2018 20:00:00
B	Area1	01/01/2018 13:00:00	01/01/2018 18:00:00
...	...	...	...

In a second table (IDOverview) the size for the each ID is listed.

IDOverview:

ID	Size
A	5
B	10
C	8
...	...

It is possible to build a chart, that shows in 10 minute steps the filling level of a specific Type?

Thanks

Flow