Hi @JPanama , thanks for the reply!
Actually I did consider that, but there a few problems with this solution.
- For metrics like ROI and ROAS the won deals would biase my reports since we don’t actually win nothing for these services.
- I still wouldn’t be able to link a specific service to a specific service provider. Like, Mike did the Electric and Joe did the Hydraulics. How many services each one did in the past 30 days grouped by type of service?
In fact, I already found a solution to this problem. I created a custom field named Work Order Number for tickets. One Work Order Number may have multiples tickets (acting as services), but each ticket have only one service provider, one type of service and one Work Order Number.
In that way, I can create custom reports controlling for distinct Work Order Numbers if I want to know the quantity and grouping to know the mean value of each one.
I appreciate your help and your time. Thank you very much.