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

Help Insights
1

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

2

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.