4 Replies Latest reply on Oct 10, 2013 5:57 AM by Dawid Nawrot

    Relative hour and minute on the line graph

    Dawid Nawrot

      Hi,

       

      I'm comparing some numbers for three previous days. I've got nice line graphs for each day in one line which is perfect.

       

      I would like to limit the graph to show only up to the current hour.

       

      I've added a filter on HOUR(Date) to be smaller or equal to the current one, and before that another relative filter on Date to show only last 3 days.

       

      I wanted to add filter on MINUTE(DATE) but I can use DATEPART('hour', [Date]) in my condition for the filter as it can only reference the field which is MINUTE(DATE).

       

      Any way around it?