8 Replies Latest reply: Nov 10, 2017 9:59 AM by Daniel Rodríguez RSS

    Working with dates - Last date

    Daniel Rodríguez

      Hello guys


      First of all thanks for your time.


      I have a set of data with measures,dimensions and dates. I've created some charts with dates,measures,etc, but I want to show just the data from the last date.


      Lets say, I want to show the sum of A over the max(date). I thought: Well, I can convert a date to number an then get the maximum:




      but it seems that it doesn't work properly. When I try to show the max(num(date)) it throws an error. Am I missing something?


      Thanks in advance