1 Reply Latest reply: Feb 12, 2016 1:48 AM by Jithu J RSS

    how to get max(date) as a dimension

    Jithu J

      I have table like this

       

      how to plot a chart to get dimension is like max(date) or previous day and I have created measure like how many created and how many submitted

       

      Thanks

       

      Ticket_noDateStatus
      11/27/2014Created
      11/28/2014Modify
      11/29/2014SUBMIT
      12/2/2014Closed
      21/27/2014Created
      21/28/2014Modify
      21/29/2014SUBMIT
      32/2/2014Created
      32/2/2014Modify
      38/8/2014SUBMIT
      43/1/2014Created
      43/1/2014Modify
      58/8/2014Created
      58/8/2014Modify
      510/8/2014SUBMIT
      68/9/2014Created
      68/9/2014Modify
      610/8/2014SUBMIT
      611/11/2014  closed
        • Re: how to get max(date) as a dimension
          Jithu J

          Date=Max(dates1) is saying invalid dimension

          I have tried Date=today()-1 for previous day but it is not showing the tickets on that day instead showing full count..

           

          I have a master calendar in the data model ... the join is b/w this table->Date and master calendar ->Date