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:

       

      max(num(date))

       

      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

       

      Regards