Min of date and max of count Tableau select max(cnt) over(Partition by video_title, country, channel order by video_title, country, channel ) as tt, a.* from ( select video_title, country, channel, post_date ,sum(count) cnt from matrixschema.facebook_post_level_derived where country = 'US' and video_title like '%Test to be searched%' group by video_title, country, channel, post_date order by post_date ) a This can be implemented in tableau as: To get min of date: {FIXED[Country],[Channel], [Video Title]:MIN([Date])} To get max of `count: SUM({ FIXED [Video Title], [Channel],[Country]:MAX([Count])}) When the max count is used in the report under measure values shelf change the aggregation type to Max( instead of Sum)