Count hourly activity of measure devices

[#1]

Dear Qlik Experts,

I have timeserie of values produced by about 200 measure devices as a CSV file.

One record (row) looks like this: timestamp (YYYY.MM.DD hour:min:sec), deviceID, value

A devices is active during several hours per day. If the devices is active it sends a data packet every 20 -30 minutes.

Now I need a list or - better - a graph displaying the number of active devices per hour.

Date             Hour    DevicesSeen

...

2015-10-17  22      20   (= 20 different devices have sent a least 1 one data packet)

2015-10-17  23      25

2015-10-18  0        21

2015-10-18  1        18

...

Best regards & many thanks in advance

Wolfgang

[Anonymous]

How about using :

     Dimernsion:          Hour

     Expression:          Count ( distinct [deviceID] )

[MarcoWedel]

Hi,

another solution could be a calculated dimension like:

Timestamp(Floor(yourtimestampfield,'01:00:00'),'YYYY.MM.DD hh')

hope this helps

regards

Marco