Skip to main content
ana_g
Helper ⭐️
Jul 10, 2019 1:59 PM UTC

Date time filter granularity in Report Builder

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!

      4 replies

      dan_ahrens
      dan_ahrens
      Expert ⭐️⭐️⭐️
      Jul 10, 2019 2:35 PM UTC
      Hi Anastassia,

      Aggregation of type MAX on last modified date is available today:



      Translate
      VP of Customer Success at Forcepoint
      ana_gAuthor
      Helper ⭐️
      Jul 10, 2019 2:39 PM UTC
      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?

      Translate
      Anastassia Goidina
      ana_gAuthor
      Helper ⭐️
      Jul 10, 2019 2:45 PM UTC
      @dan_ahrens Here is an example



      Translate
      Anastassia Goidina
      dan_ahrens
      dan_ahrens
      Expert ⭐️⭐️⭐️
      Jul 10, 2019 2:55 PM UTC
      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:



      Translate
      VP of Customer Success at Forcepoint
        Terms & ConditionsAccessibility statement