Solved

Ability to subtract the count of an event from the count of another event

  • 8 January 2024
  • 1 reply
  • 23 views

I’m new to Heap and reporting, so wondering if the below is possible.

 

Id like the ability to count the number of active templates my users have on our platform.

I currently have 2 events going into Heap:

  • Template created
  • Template removed

I am able to work out how many active templates exist by subtracting the events from each other:

<template created> minus <template removed>

 

I want to know whether it is possible to draw up a chart in Heap in this way? I’d then like the ability to group by user, to show how many active templates (on average) each user has.

 

Is this possible? Thanks

icon

Best answer by Preetam Barik 24 January 2024, 09:24

View original

1 reply

Badge +1

Hi @ameliasw ,

 

There is no direct option to subtract the occurrences of 2 events. However , you can try a workaround which I believe will give you the most close results.

 

1. Use the first event as template created
2.In the filters apply users who have not done template removed.(add any specific date range/anytime)
3. This will try to remove those segments of users who have not done Template removed or we can call as Active Users.

Do let me know if this worked for you!!

 

Thanks and Regards,

Preetam

Reply