Skip to main content
cmultanen
Helper ⭐️
June 17, 2020
New Idea

Idea: Increase Number of Allowed Formula Fields in Transform Tasks

  • June 17, 2020
  • 2 replies
  • 101 views

There is currently a limit of 10 formula fields per Transform task in Rules Engine. It would be nice if this limit was increased so that we don’t have to create multiple Transform tasks for the same source data.

 

 

2 replies

rakesh
Gainsight Employee ⭐️
Lets put your data to work!
July 7, 2020

Hi @cmultanen 

From what we see, generally people create 2-3 formula in one transformation task. Can you share how frequently you face this challenge? 

Also, curious to know why would you do so many formulas as part of a bionic rule? 

cmultanen
cmultanenAuthor
Helper ⭐️
July 7, 2020

Hi @rakesh, we face this challenge when we are trying to process raw usage metrics from S3 set up by our Data Team. The issue is when the values are percentages but appear as a value from 0 to 1, i.e. .95. In those cases, we need to transform the metrics so that they appear properly in reporting and on C360/R360 pages.