I have the following search which returns the avg number of "EnterPlace" actions in a session (a transaction = a session) by month.
Each "EnterPlace" actiontype also has a placeid.
The problem is that we need to calculate the avg number of EnterPlace actions with unique placeid in a session (ie. if a transaction had two logs with actiontype="EnterPlace" and both logs had the same value for the world_id, then the count for that transaction should be 1).
Is there a way to do that?
Really appreciate your help.
This is what I have so far, which needs to be corrected:
the problem is that dc should be on a different field than the mvexpand and only conditionally:
the events of a transaction have different values for actiontype.
so, for each transaction, only for the events that actiontype=EnterPlace, I need to do dc(world_id). and then average out the dc value over all the transactions.