4 Replies Latest reply on Jan 7, 2019 5:42 PM by Peter Fakan

    Include only most recent data from SQL data source

    Aleksandra Shander

      I am trying to pull in a table from SQL database that is refreshed monthly; I only want to be able to visualize the data from the most recent refresh and not the rest. There is a column that indicates refresh date, and I want to use data only from MAX [refresh date field]. How can I do that?

       

      I've tried to create custom field with FIXED : MAX parameter - I was unable to then filter on that successfully.

       

      Can someone recommend a way to get Tableau to only show the data set matching a MAX value in a particular field?

       

      Data source: SQL Extract (my access is read-only)

      Tableau version: 10.5