Group dimension 'Time' in a diagram

[#1]

Hi all,

I am analysing data from production machines and have to calculate continously for 3-minute-periods the number of good and bad parts produced.

The result should be shown in a bar Chart (one bar for every 3-minute-period).

However, I didn't get it.

I have a Dimension 'timestamp' with date and time for every produced part. But I don't know how to realise the caculation based on a 3 minutes period.

Can anybody help a QlikView freshman?

Thomas

[marcus_sommer]

You need an extra dimensions for this, maybe so:

ceil((minute(TIMESTAMP) + 1) / 3) as MinutePeriod

- Marcus