コメント
-
@MichelleH the issue there is that I want the rank to by dynamic based on the date range being filtered by the user. If I rank in the ETL, the date would be unknown. Is there a way around this or maybe a different filtering method to filter the minimum rank rather than rank = 1 since regardless of window, the lowest rank…
-
@TimD that sounds great. Can you post the spreadsheet?
-
The thing is that I need the value of the equation to equal the entire month. Provided today's date, I need it to calculate the number of business days in all of October. In my data, a single row is a month, so I would need to calc to understand that it's October and be able to tell me how many days there are in October…
-
Wow, @nmizzell, that was everything I was looking for and more. Incredible stuff and I truly appreciate the walkthough you provided. 🙌. Many, many thanks!
-
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`)
