5 Replies Latest reply: Feb 17, 2016 11:43 AM by Gysbert Wassenaar RSS

    Need duration to be displayed in timeline chart

      Hi,

       

      In a bar chart used one regular dimension and a value list ( (i.e) - ValueList('StartDate','FinishDate ) under dimensions and in measures used below expression

      It displays a date value way far behind as in screen below, but Need to display duration of days on Mouse over in bar chart for timeline.

       

      if(ValueList('StartDate','FinishDate')='FinishDate',

      max(DayEnd(FinishDate))-Min(DayStart(StartDate))

      ,Min(daystart(StartDate))

      )

       

      Post.png

      Any advice would be appreciated?


      Regards,

      Radhakrishnan