On our dashboard we have two donut charts called ‘Gross Margin (%)’ and ‘Conversion Rate’. We are trying to calculate a budget variance for these metrics (calculated as Variance = Actual Value - Projected Value). The main problems are that the ‘actual value’ in these cases are dynamic values and are not stored anywhere on Hubspot besides the charts.
For example, the Gross Margin (%) chart is a donut chart made up of the Gross Margin Value and the Non-Margin Value (calculated as the Full Tender Value - Gross Margin Value), and the relevant value here would essentially be the Non-Margin Value/Full Tender Value (14.07% in this case):
Is there a way to create an automatically-updating property to store these numbers?
Thank you!
