Skip to main content
Released

Field Comparison in Reports

Related products:CS Reports

logan_t
  • Contributor ⭐️⭐️⭐️
  • 12 replies
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 = 😵 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.

6 replies

dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • 1984 replies
  • August 16, 2017
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). 

spencer_engel
Forum|alt.badge.img+4
  • Expert ⭐️
  • 669 replies
  • January 11, 2018
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.

joseph_siudzinski
Forum|alt.badge.img+2
+1 to this. Super valuable in bionic rule transformation, really need it for reports as well.

spencer_engel
Forum|alt.badge.img+4
  • Expert ⭐️
  • 669 replies
  • November 17, 2021

I assume this should be marked as “Implemented”, right? Since we can now compare string fields in HA.


anirbandutta
Forum|alt.badge.img+2
  • Expert ⭐️
  • 1804 replies
  • November 18, 2021

@Azad can you pl confirm and we can then update the Idea status?


Azad
Forum|alt.badge.img
  • Gainsight Employee ⭐️
  • 95 replies
  • November 18, 2021

Yes this was implemented with HA. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings