Timeseries with zero values

[ThomasKrummenacher]

Hi,

I am trying to create a complete time series.

The number is calculated from Count (Distinct (document)).

I implemented the time series as a "detached" dimension.

Time	Count
00:00 - 00:59	1
01:00 - 01:59	2
02:00 - 02:59	5
03:00 - 03:39	23
04:00 - 04:59	54
....
23:00 - 23:59	12

My problem now is that the time series no longer shows positions with count = 0.

The number of positions should also be retained if, for example, a product should be selected.

Only the number calculation should react to the selections. Thanks for your support.