http://m.getsatisfaction.com/topics/7315303 Report builder: MIN & MAX aggregation for date fields 2018-08-09T15:57:12Z 2016-09-21T18:48:41Z 7315303 http://m.getsatisfaction.com/topics/7315303 7315303 Report builder: MIN & MAX aggregation for date fields 2018-08-09T15:57:12Z 2016-09-21T18:48:41Z Max Hinze http://m.getsatisfaction.com/people/8661815 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10907576/photo_medium.jpg max_hinze Hej &nbsp;Gainsight community,<br /><br />I am surprised that I cannot us a MIN or MAX aggregation on date fields when using the report builder.&nbsp;<br /><br />Maybe I am just unable to find out how it actually works, or no one else needs such a aggregation on data fields when building reports &amp; dashboards. But I would really appreciate to have such an option.<br /><br />Please, dear GainSight peeps let me know if there is a work around or, in case this is really not possible, if you have planed to add this function.<br /><br />Best regards,<br />Max idea 4 12 6 comment http://m.getsatisfaction.com/topics/7315303/replies/17908602 http://m.getsatisfaction.com/topics/7315303 17908602 Lila Meyer responded to "Report builder: MIN & MAX aggregation for date fields" 2016-10-10T17:04:02Z 2016-10-10T17:04:02Z Lila Meyer http://m.getsatisfaction.com/people/7406309 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11245928/LilaMeyer-headshot-2018_medium.jpg lmeyer_gainsightcom Hi Max,<br /><br />It looks like Max/Min is available on some date fields in the report builder, but not all. I've tagged our product manager for more information. 0 http://m.getsatisfaction.com/topics/7315303/replies/19325186 http://m.getsatisfaction.com/topics/7315303 19325186 Heather Landgraf responded to "Report builder: MIN & MAX aggregation for date fields" 2018-02-15T18:23:05Z 2018-02-15T18:23:05Z Heather Landgraf http://m.getsatisfaction.com/people/7877159 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11276402/headshot2018copy(2)_medium.jpg heather_landgraf I need this too.&nbsp; I need to build a report on a specific set of CTAs (recurring) and the MAX close date to see the last time a CTA of a certain type was closed.&nbsp; I cannot seem to find a way to do that in reporting.&nbsp; It won't let me do MAX close date.&nbsp;&nbsp; 0 http://m.getsatisfaction.com/topics/7315303/replies/19637073 http://m.getsatisfaction.com/topics/7315303 19637073 Calvin Multanen responded to "Report builder: MIN & MAX aggregation for date fields" 2018-07-13T14:29:05Z 2018-07-13T14:29:05Z Calvin Multanen http://m.getsatisfaction.com/people/9300190 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11206439/profilepic_medium.jpg calvin_multanen Is there any update on which fields/objects MIN and MAX aggregation are available for, if at all? I'd like to create a CSTask report for the current open task in a playbook by MIN due date. This would really help our managers know where their team members are in a playbook. 0 http://m.getsatisfaction.com/topics/7315303/replies/19686816 http://m.getsatisfaction.com/topics/7315303 19686816 Matthew Lind responded to "Report builder: MIN & MAX aggregation for date fields" 2018-08-09T15:57:12Z 2018-08-09T15:57:12Z Matthew Lind http://m.getsatisfaction.com/people/7547391 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10542606/photo_medium.jpg matthew_lind I was just in search of this myself, and surprised I couldn't use MAX/MIN on date fields. My use case is to identify the most recent touch to a customer. I promised this to a member of management, and now I'm having to backtrack.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />My observation (untested, and based on a very small number of spot-checks) is that you can use MIN/MAX on date fields residing in MDA objects, but cannot use MIN/MAX on date fields in SFDC objects. That makes MIN/MAX unavailable for Customer Info, Account and CTA objects.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I suppose the work-around is to write a "Load to MDA" Rule to shuttle the SFDC date-based data to the MDA, but what a hassle. 0