Buğra Gündüz
Merged in a post:
Subtraction (and other formula logic) in a number report
D
David Lum
I am trying to show the impact of marketing by the increased deal size with a marketing touchpoint compared to without a marketing touchpoint. I've done this with two separate number reports, but what would be great is if there was logic to calculate the difference in a single number report. This can be accomplished by creating formula logic within reports to take one ratio (or single data measurement) and subtract it from another ratio (or single data measurement).
Buğra Gündüz
Merged in a post:
Support for Calculated Fields in Reports
A
Andrew Strom
We are looking for support of creating calculated fields within HockeyStack report building. HockeyStack collects a lot of data points and we'd like to use these data points to create calculated values within reports. A couple of examples of calculations we'd like to see below:
1) ROI calculation for channel spend = [(Pipeline Created Amount - Channel Spend Amount) / Channel Spend Amount = Channel ROI]
2) Conversion-adjusted projected ARR = [Total Open Pipeline x Average Opportunity Close Won Rate = Expected Closed Won ARR]
3) Total pipeline growth & currently open pipeline = [Existing Open Pipeline + New Pipeline Created - Closed Won Pipeline - Closed Lost Pipeline = New Total Pipeline Open]
4) Historical average days in each opportunity stage = [Total # of Days in Stage for All Opps Ever in Stage / Total # of Opps Ever in Stage = Average Days in Stage]