Good day! Can you tell me if it is possible to do the following with standard functions?
There are two events - A and B
Event B, using the event parameter rootID refers to a specific event A.
That is, the structure is as follows:
- Event A
- ID - 001
- Event B
- ID - 6901
- ROOTID - 001
- Event B
- ID - 6902
- ROOTID - 001
I want to get a result of the formq
Number of unique events A, broken down by ID, each breakdown shows the number of events B of this event A