We just came across a use case for filtering by most recent GS Modified Date (we don't want deleted records from our internal system being shown in the report and have found that they do not get a GS Modified Date). I noticed that a record that was pulled in at 5am wasn't pulled in at the next run because it was deleted, but I am only able to filter to GS Modified Date = Today. I'd love to be able to do something like MAX of GS Modified Date to only show the most recent records for accurate reporting.
Not sure if this will be possible through the formulas coming out soon, but eager to find out!
Page 1 / 1
Hi Anastassia,
Aggregation of type MAX on last modified date is available today:
Aggregation of type MAX on last modified date is available today:
Hi Dan, I'm not looking to aggregate or show that field in the report. Is it possible to just have it as a filter?
I might not be following what you're trying to achieve fully, but just remember that if you have a single record per row as shown in your example, then there will be one "last modified date" per row which will essentially show the "max of modified date" per record.
If you just wanted to show the most recent rows that were updated, you could also use the ranking feature:
If you just wanted to show the most recent rows that were updated, you could also use the ranking feature:
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.