New Custom Field Type - Calculated Field

Who would benefit?

All Aha! Users

What impact would it make?

Significantly improve the reporting experience and provide users access to real time data at the record level.

Users would be able to essentially add a calculated column by adding a data column without having to build the underlying formula because it was pre-determined / configured at the field level.

How should it work?

Add a single cell calculated field where the built in equation builder can be used to calculate the field. The field ideally would be updated in real time, Eg, if you had a calculation that was comparing the difference in days between a custom field and today, users could look at the record one day and see a value of 7 days and the next day they would see a value of 8 days.

Right now this is possible at the report level, but anytime you create a report, you have to create a new calculated column.

While Worksheet custom fields provide this functionality at a larger scale - I'd like the option of being able to add a calculated field into a record's layout without having that calculation included as part of a table but rather a single result so that it blends in seamlessly with other fields. Worksheet custom fields also add unnecessary length to the field name by default when adding a calculated result as a data column in a report by prefacing it with [WORKSHEETNAME]:[CALCULATION] and this simply causes extra steps that need to be performed when dealing with simple calculations.