How to transform new column based on existing data. Is that possible using Insights

How to transform new column based on existing data. Is that possible using Insights

If you go to your insights link and add /app/data to the end (https://yourinsightslink.com/app/data) you get into the ElastiCube part which looks like this:
image

You can click any of the circles, and click the magnifying glass icon, that appears on top
image
Click the blue button “+ column” at the top right.

An example of a formula for a column that you could name TransactionDurationMinutesGrouped would be:

IfString([TransactionDurationInSeconds]<120,'0-2',IfString([TransactionDurationInSeconds]<240,'2-4',IfString([TransactionDurationInSeconds]<360,'4-6',IfString([TransactionDurationInSeconds]<480,'6-8','>8'))))

You can click the preview button to see what your data would look like.