Field Comparison in Reports

  • 6
  • Idea
  • Updated 3 months ago
  • Under Consideration

Hey Team,

This is Logan from Support. We've recently had a few requests for some additional features in the Report Builder's Advanced Logic that seem like great ideas!

Specifically, the ability to compare two fields to narrow down results. 

For example:

  • (Created By = X) AND (Assignee = X)

In this case, we would be looking for records where both the "Created By" would also have a "Assignee" of the same user. 

But we would need the ability to add variables in here, as we wouldn't want to specify which user exactly. 

In our Rules Engine "Setup Action" additional criteria, we have the ability to add a filter saying "Created By = FIELD (or VALUE)". This same type of filtering would be beneficial in the Reports for showing granular results that our users are looking for!

Thanks for the help! I'd be happy to provide additional information if requested.

Photo of Logan T

Logan T, Employee

  • 3,134 Points 3k badge 2x thumb

Posted 1 year ago

  • 6
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 24,802 Points 20k badge 2x thumb
I'll +1 this idea. It came up with me today on a call with a customer who was looking to do that exact same type of logic - comparing the values of two fields and filtering based on if the two fields were identical (or not identical). 
Photo of Spencer Engel

Spencer Engel, Employee

  • 5,636 Points 5k badge 2x thumb
Yeah, +1 here as well. I could definitely use this for one of my customers. Without this capability, the only option is to write a bionic rule and loading values to another MDA object, which in my opinion, is way too cumbersome of a process.
Photo of Joseph Siudzinski

Joseph Siudzinski, Employee

  • 5,352 Points 5k badge 2x thumb
+1 to this. Super valuable in bionic rule transformation, really need it for reports as well.