Our website has two different internal searches: search type a and b. It gets differentiated by a prop called search type and also an evar with the same name.
My goal is to get a dwh export on hourly basis for visits with only one search for searchtype a and vs. visits with searchtype a more than 1.
I have tried using a sequence segment with a then condition plus including anjd excluding, but due to the sequence I am not able to use this for dwh export.
I have also tried created a calculated metric but this is another restriction from the dwh.
Does anyone know a better solution on this?
I would need a segment which for examples says something like evavr search type instance equals or greater than 2 but both must also be search type a, because if I would use it like this it would also count for search type b.
I hope someone knows a better solution and I dont get why there is such restriction on Adobes side for calculated metrics and sequence segments.