Count first occurrence of event if another event not present in the same date

[Devel82]

Hi,

I'm trying to select a type of event and to count its first occurrence, only if another type did not occur on the same date.

This is an example that selects only the type:

Count({<[events.type] = {'open'}, [group_batch] = {"batch01"}>} [events.type] )

I have some objects ("hardware key") that have a lot of events.

I need to count only the first occurence of event type "open" for every object to open ("hardware_key"), excluding the day where another event type ("installation") occurred

Can anyone help me?

Thanks in advance,

Giacomo

[chrismarlow]

Hi,

You may need to share some sample data/screenshots tagged up with which instances you expect to be included in the count, so for example it is not clear how you would identify events being on the same day from your post.

Cheers,

Chris.

[Devel82]

Data Structure

Hi Chris,

This is data structure. I need to count first occurence of events.type "Open Cap" for every different events.public_key in every day where there is no events.type "Installation"

Thanks very much,

Giacomo