9 Replies Latest reply: May 21, 2014 4:30 AM by Nitin Gupta RSS

    Hourly data, showing only date on x-axis

    Mika Lindman

      Hi,

       

      I have hourly data on a line chart, and I'm using calculated dimension to show only date on the x-axis.

       

      =date(MyDateTime, 'dd/MM/yyyy')

       

      This gives me hourly data without having timestamps on x-axis.

       

      Is there any way to show only distinct dates on the x-axis, instead of having the same date repeat as many times as it fits in the chart?