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:
You can click any of the circles, and click the magnifying glass icon, that appears on top
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.