I have a data set that looks like the one below. Each date represents a session for a given client. All I want to do is to create a new dimension that is 1 for the first session, 2 for the second session, 3 for the third session, etc. I tried index and rank and can't figure out how to do this so that I can later use the session dimension on columns in a bar chart. Please advise! Thanks.
10 respuestas
Hi, Amelia
thx for the workbook, please find my solution attached as well as below steps
And this is how the bar chart looks like
Workbook attached for your reference.
Hope this helps
ZZ
