4 Replies Latest reply: Apr 2, 2013 4:40 PM by Emma Dickson RSS

    Attempting to use the no. of days between two dates as a calculated dimension?

      Hi please advise...

       

      Am currently using:

      =Interval(date(Tran_date,'DD-MM-YY')-date(Film_OpeningDate,'DD-MM-YY'),'d')

       

      as the calculated dimension in a bar chart, but this returns a single bar, rather than individual bars for separate numbers of days?

       

      Many thanks,