Solved

Combine custom events

  • 17 February 2021
  • 3 replies
  • 23 views

I have created four custom events from a single, existing event (based on different property combinations) to allow me to show four separate lines on an Insight report. I would like to have another line on the report which is essentially the total of the original event less the total of the other four custom events. My problem is that two of the events have property checks that are mutually exclusive and therefore would require an and+or filter to build the inverse of the four events.

Is this possible? 

icon

Best answer by Muffaddal Qutbuddin 17 February 2021, 19:44

Hello @Andy Noble , If I understand you problem correctly, you can use formula to subtract total of 4 events from main events. Suppse A is the main event and B to E are the 4 events. You can create 5 formulas to get you 5 lines.
Formula 1 = A - (B+C+D+E)
Formula 2 = B
Formula 3 = C
Formula 4 = D
Formula 5 = E

 

 

View original

3 replies

Userlevel 2
Badge +2

Hello @Andy Noble , If I understand you problem correctly, you can use formula to subtract total of 4 events from main events. Suppse A is the main event and B to E are the 4 events. You can create 5 formulas to get you 5 lines.
Formula 1 = A - (B+C+D+E)
Formula 2 = B
Formula 3 = C
Formula 4 = D
Formula 5 = E

 

 

Hi @Muffaddal Qutbuddin - thank you this works a treat. Much obliged

Userlevel 2
Badge +2

Hi @Muffaddal Qutbuddin - thank you this works a treat. Much obliged

Glad I could help.

Reply


Mixpanel