9 Replies Latest reply: Nov 16, 2017 10:22 AM by Sunny Talwar RSS

    Reagarding Max(date) and Total communication (YearTD)

    ramesh konda

      Hi,

       

      I'm unable to use Max(date) on timestamp date column, where i need to pick the max(date) of the user and need to find his (Total YTD) communication.

       

      I have 4 Columns in my report, Date, CustomerName, Communication type.

      This interaction will happen on the map, when I click on CustomerName in the map Then i need to show his related data in the table view with ( his Last Max(date) which is a timestamp column, his Name, and his total interaction YTD ) into a single row.

       

      I'm not able to run Max(date) on that date col and not able to calc YTD interactions.