Custom Formulas in a Column Summary

Column summaries are a useful tool for visualizing and aggregating data, but they are currently limited in functionality. I think it would be great to be able to define a custom formula to calculate the results of a column summary. Specifically, I am trying to address this issue:

  • We integrate with SurveyMonkey to bring our NPS and CSAT scores into and associate them with customers and accounts. This is working well
  • Currently, I can only see the “raw” scores and I have not been able to find a way to calculate the actual CSAT and NPS scores “vertically” without exporting the data to Excel

If we could define a custom formula in the column summary, that would resolve this issue.