tmerchant Member

Comments

  • hi @david_cunningham thank you for your reply! tried breaking it up and am immediately running into Calculation Error : Aggregate functions are not allowed in this context: 'SUM'. which is another error I'm seeing for the very first time. I know this is a typical error for WHERE nested within SUM, which isn't the case…
    in Run rate beastmode calculation Comment by tmerchant May 13
  • Hi @MichelleH thanks for answering! The above gives me the count of each unique ID, which is 1, but I want the count of each unique ID per month-year. For instance, I want it to say 15 in the Count of ID column in the screenshot below. Is there any way to specify that within the Group By function? Did I perform the…
    in Count Unique IDs by Month-Year Comment by tmerchant March 2023
Default Avatar