3 Replies Latest reply on Aug 27, 2016 11:53 AM by David Li

    Average of Sales by Minute over 12 months

    Badri Narayanan

      I have requirement where i have minutely sales data over last 12 months. I need to plot graph where my X-Axis is Hours & Y-Axis is Sales, will have line plots minute by minute data points

      I will have 1 lines showing avg for that data point last 12 months. I'm doing something like this:



      iif(datediff('month',[EST Event Time],DATE('17-August-16')) <= 12,[Metric Amount],0)/60 which will avg it out by minute . Is this right?