user060355

Woah.. that made all the difference. I was limiting the data to the last 12 months! Thank you for all your help!!!

It's so bizarre. I'm using the exact same calculations for year and month.

@MarkSnodgrass I have, but I cannot seem to get the same month of different years next to each other. It never alternates the way I want. I see all of 2022 then all of 2021 regardless of their order

That worked! Thanks!

Hmm... Doesn't seem to be working. It seems bizarre that this is difficult.

@MarkSnodgrass if I am graphing count(id) over time, how would I change your formula?

That simply changes the label. It does not appear to have an impact on the values in the chart. As you can see in the image, the scale on the left is not percent of total.

My apologies. I thought I had provided sufficient information in my question, but I did not :/ . I am trying to calculate customer lifetime value and there are additional columns I want to be able to group on as well such as the office the client visits. I'm not looking to actually include the client's ID in the final…

@GrantSmith @jaeW_at_Onyx Genius! Mind blown :) Thank you!

What do you mean by "append the dataset onto itself"?

Oh boy. I just realized I should have written: sum(case when excuse = "no show" then 1 else 0 end)/count(`id`)