4 Replies Latest reply on Dec 4, 2013 11:39 AM by Amy Song

    Calculated field with an aggregated function based on time

    Amy Song

      Hi there,

      Trying to figure out this "can not mix aggregated and non-aggregated arguments to function" error I'm getting.

       

      In the attatched example using superstore, I am trying to view total sales, October sales, total customers, and October customers by state.  I am able to view October sales using this calculation: iif(month([Order Date])=10,[Order Quantity],0)

       

      I get the error when trying to use it for customers, which is an aggregated calculation: count(Customer)

       

      I tried to use the attr on my month, but that didn't seem to work either.

       

      Thanks!

      Amy