I've been working on this question for several days and can't seem to get the answer, even though it seems straight forward.
I have a table in this format, which is essentially a funnel (the numbers indicate whether they got to that step):
I then have a statement that says
GREATEST(step.a,step.b,step.c,step.d), that gives me the highest step for each ID. This is what that output looks like:
So the highest step ID
5467894 gets to is
3438431 gets to
4574321 gets to
What I need to show is the # of IDs that got to each step, because if an ID got to
step.c, then they got to
step.b as well. If an ID got to
step.d, then they went through
Looking at my 'greatest' column above, I should have the following:
|step||# of IDs|
For my end result, I just need to show how many IDs are in each step. I am using DataGrip and QuickSight, and I can use either to calculate the column. I don't need to use the GREATEST() command, just an idea I had. Any help would be greatly appreciated. Thank you so much.