To create a custom event named "REFERRAL.JOINED" based on your existing "REFERRAL.SUCCESSFULL" event, you can use Mixpanel's Custom Events feature. Here's how you can do it:
1. First, navigate to Mixpanel's Custom Events feature. You can find this in Lexicon.
2. Click the plus button to the right of the search bar to create a new custom event.
3. Name your custom event "REFERRAL.JOINED".
4. In the formula bar, you'll define the custom event. You'll want to use the existing "REFERRAL.SUCCESSFULL" event and change the distinct_id to the toUserId. Here's an example of how the formula might look:
```
event("REFERRAL.SUCCESSFULL") {
set(properties.distinct_id, properties.toUserId)
}
LBKSThis formula takes the "REFERRAL.SUCCESSFULL" event and sets the distinct_id to the value of the toUserId property.
5. After defining your formula, click "Apply" to test it in your current analysis, or "Save" to make it available for future use.
Remember, custom properties are local to the report by default when you select "Apply". To save the custom property permanently for use in other reports and to make it usable by other project members, click "Save" [Custom Properties](https://docs.mixpanel.com/docs/features/custom-properties#creating-a-custom-property).
Please note that this is a high-level approach based on the information provided in the Mixpanel documentation. The exact implementation might vary depending on your specific Mixpanel setup and data structure. If you encounter any issues or need more detailed guidance, I recommend reaching out to Mixpanel's support team for assistance tailored to your specific project setup.
