2 Replies Latest reply on Dec 6, 2016 10:23 AM by Jeremy Harris

    Mixing Aggregate and Non-Aggregate For a Filter

    Eliza Caplan

      I am trying to create a filter to filter on the most recent time period (by month and year). To get the most recent month/year for the data set, I had to create a calculated field-- max(month(date)). I set this calculated field equal to year(today) and month(today), so that I can filter "True" to only include data from the most recent time period. Because I used "max" in the original calculated field, it shows the error "cannot mix aggregate and non aggregate". How could I make this work?