Bionic Rules: Ability to use Date functions while Pivoting data based on Date

  • 1
  • Idea
  • Updated 8 months ago
  • Under Consideration
In rules engine if we have to do  pivoting based on date we need hard code dates(screenshot Attached) and there is no way to provide dates dynamically using date functions.

Recently we have a use case where customer want to have their weekly usage  up to 12 weeks for a metric in single row to show week on week comparison. We couldn't  create a Pivot  task to do this as there is no way to pass dates dynamically.  Having this feature would really helpful in solving these  type of Usecases.
Photo of Himabindu Nemagadda

Himabindu Nemagadda, Employee

  • 70 Points

Posted 9 months ago

  • 1
Photo of Sundar

Sundar, Employee

  • 11,178 Points 10k badge 2x thumb
If the unique values of the dates run into thousands then you would have so many columns. This is one of the reason why picking up a dynamic value is not implemented yet.

One solution for that would be have a formula field that gives out the Month number or label. Use that limited values in this pivot screen.