11 Replies Latest reply on May 10, 2018 12:43 PM by Jim Dehner

    My calculated field is behaving differently than desired, what am I doing wrong?

    Jessica Singer

      I'm trying to calculate how many users at each site are what I've called "high attendance", or have attended more than 4 seasons at that site.  I've built a calculated field that does generate correct labels at the row level (see Sheet 2). However, when I aggregate to the Site level in the view (see Sheet 1), I want the three levels of attendance to be separate columns, and to return how many individual users fall into each category. But I get a single aggregated number instead. Obviously I'm doing something wrong (this should be a LoD expression instead?) but I don't know what.