counting multiple results from pivot table

[#1]

Dear all,

I have created a pivot table which shows the maximum number of cases per hour for every day and hour in the calender.

This value already represents the maximum number cases per hour (according to a "minute calender" in the background).

The formula I have used is:

max(aggr(count(CountID), Datum_time))

What I'd like to do next is to count the distribution of the cases on a hourly base, like:

• how many times "0 cases" from "00:00 - 01:00"
• how many times "1 case" from "00:00 - 01:00"
• how many times "2 cases" from "00:00 - 01:00"
• how many times "3 cases" from "00:00 - 01:00"
• how many times "4 cases" from "00:00 - 01:00"

• and so on... (same for "01:00 - 02:00", "02:00 - 03:00", etc)

The result should be available in another table with the number of cases as columns and the hours as rows.

I have been thinking about how to do this the whole weekend until now and don't see a solution yet (I even did not find any solution in the community). Since I am not too experienced with QVW maybe I just missed the answer to this simple question.

Any suggestion is most welcome! Thanks.

Nico