Min/Max Date fields in Rules Engine

Related products: CS Rules & Permissions
It has been brought to supports attention that when using MIN/MAX operations on a date field in a SOQL query it changes other fields to the opposite operation. 





For Example: You want to view the last record of the month. You use MAX of Date and you get the following. 





Show: Max of Date, (MIN of) field 1, (MIN of) field 2, (MIN of) field 3.





Is it possible to get a popup in rules engine setup screen that when selecting MIN/MAX that we display a popup that lets users know that SOQL queries behave in this way? OR Could we make it like report builder and when you select MAX/MIN then it automatically changes the affected fields to what the query is returning?? 





Unless you have a good understanding of each of the records returned in the set, it is very tough to spot what the query is ACTUALLY doing and usually it takes support awhile to debug. When this happens, the excel spreadsheet doesn't even show the behind the scenes operator changes. 





With a pop-up, users that don't understand could at least be prompted to reach out to support before setting up a rule that likely won't be working as intended anyway. 
This would also be good to outline in our documentation regarding these operators.  The key is that selecting a MIN/MAX aggregation is NOT selecting a record, it is performing a function on that field (which is find the MIN/MAX in summary for all records).  What we should highlight in docs and in Rules (help text perhaps) is what happens with other fields in your rule.  The assumption users always make is that we are selecting a record vs performing an aggregation on that field.  (Would be a good feature though to actually pick the record and use other field values from it)
I added some explanation toward the end of this article on the Min/Max function, but let me how if we should expand or clarify.





https://support.gainsight.com/Product_Documentation/Rules_Engine/Admin_Configuration/Using_Calculate...
This is possible with Bionic rules that came out with 5.5 release. Another thread on the same line
article not found.


It looks like you encountered an old link, https://support.gainsight.com/hc/en-us/articles/204520238?_ga=1.52918248.1374523.1453843411
Here's the new url:





https://support.gainsight.com/Product_Documentation/Rules_Engine/Admin_Configuration/Using_Calculate...
Terms & ConditionsCookie settings