Hello!
I'm trying to get a window function to work while creating a beastmode so it can be dynamic for my users. I'm trying to show the unique number of users partitioned by rubric.
So, my beastmode is COUNT(DISTINCT `user_id)) over (partition by `rubric_id`). This works when I just show the beastmode:
However, when I then put in the different standards for that rubric (you can have multiple standards in a rubric) it breaks on me and shows me this:
What I really want is for it to show me just one standard (currently it repeats all of my options twice) and for it to have the original 5,741 number for each row. Any insights into what I'm doing wrong and how I can get where I am trying to go?