Skip to main content
A
ana_g
Helper ⭐️
July 10, 2019

Date time filter granularity in Report Builder

  • July 10, 2019
  • 4 replies
  • 130 views
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 ⭐️⭐️⭐️
      July 10, 2019
      Hi Anastassia,

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



      VP of Customer Success at Forcepoint
      A
      ana_gAuthor
      Helper ⭐️
      July 10, 2019
      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?

      Anastassia Goidina
      A
      ana_gAuthor
      Helper ⭐️
      July 10, 2019
      @dan_ahrens Here is an example



      Anastassia Goidina
      dan_ahrens
      dan_ahrens
      Expert ⭐️⭐️⭐️
      July 10, 2019
      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:



      VP of Customer Success at Forcepoint
        Terms & ConditionsAccessibility statement