Forum Discussion
Funnels with cumulative user count
Anonymous
pls see the attachment below
Hi ryan_mayu
thanks for replying.
My requirement is to see the users who followed process i.e 1st signed up 2nd field created 3rd field viewed.
the users who did first step should only come in 2nd step, same if user has done 1st and 2nd step then only he should come in 3rd step.
the solution you provided has all the users in 2nd and 3rd bar's.
Super UserAnonymous
pls see the attachment to check if this is what you want
Hi ryan_mayu ,
thank you for reply. it solved the problem for one funnel,
i have requirement for other funnel where i have 6 events which also should follow the same process i. e users who did first step should only come in 2nd step, same if user has done 1st and 2nd step then only he should come in 3rd step , same if user has done 1st,2nd,3rd step then only he should come in 4th step,same if user has done 1st,2nd,3rd,4th step then only he should come in 5th step,same if user has done 1st,2nd,3rd,4th,5th step then only he should come in 6th step.
can you please let me know how to handle this case?
i tried myself from your inputs in the file could't acheive this.
Thanks in Advance,
Suyog Ichalakaranji
- ryan_mayu
Anonymous
I think the DAX will be more complicated. Please provide the sample data.
Hi ryan_mayu ,
here is sample data, sorry i am not sure how to attach excel sheet here so pasting the Sample data here.
Event Event Date Event id User id Signed up 01-05-2022 1 User1 Field Created 01-05-2022 2 User1 Field Viewed 01-05-2022 3 User1 Map Recommended 02-05-2022 4 User1 Map Created 03-05-2022 5 User1 File Exported 04-05-2022 6 User1 PDF Exported 05-05-2022 7 User1 Signed up 01-05-2022 8 User2 Field Created 01-05-2022 9 User2 Field Viewed 01-05-2022 10 User2 Map Recommended 02-05-2022 11 User2 Map Created 03-05-2022 12 User2 File Exported 04-05-2022 13 User2 PDF Exported 05-05-2022 14 User2 Signed up 01-05-2022 15 User3 Field Created 01-05-2022 16 User3 Field Viewed 01-05-2022 17 User3 Map Recommended 02-05-2022 18 User3 Map Created 03-05-2022 19 User3 File Exported 04-05-2022 20 User3 PDF Exported 05-05-2022 21 User3 Signed up 01-05-2022 22 User4 Field Created 01-05-2022 23 User4 Field Viewed 01-05-2022 24 User4 Map Recommended 02-05-2022 25 User4 Map Created 03-05-2022 26 User4 File Exported 04-05-2022 27 User4 PDF Exported 05-05-2022 28 User4 Signed up 01-05-2022 29 User5 Signed up 01-05-2022 30 User6 Field Created 01-05-2022 31 User7 Field Viewed 01-05-2022 32 User7 Map Recommended 02-05-2022 33 User8 Map Created 03-05-2022 34 User8 File Exported 04-05-2022 35 User8 PDF Exported 05-05-2022 36 User8 Field Created 01-05-2022 37 User9 Field Viewed 01-05-2022 38 User9 Field Created 01-05-2022 39 User10 Field Viewed 01-05-2022 40 User11 Map Recommended 02-05-2022 41 User12 Map Recommended 02-05-2022 42 User13 Map Created 03-05-2022 43 User14 Map Created 03-05-2022 44 User15 Signed up 01-05-2022 45 User16 Field Created 01-05-2022 46 User16 Field Viewed 01-05-2022 47 User16 Map Recommended 02-05-2022 48 User16 Map Created 03-05-2022 49 User16 File Exported 04-05-2022 50 User16 PDF Exported 05-05-2022 51 User16 Signed up 01-05-2022 52 User17 Field Created 02-05-2022 53 User17 Field Viewed 03-05-2022 54 User17 Map Recommended 04-05-2022 55 User17 Map Created 05-05-2022 56 User17 File Exported 05-05-2022 57 User17 Signed up 01-05-2022 58 User18 Field Created 02-05-2022 59 User18 Field Viewed 03-05-2022 60 User18 Map Recommended 04-05-2022 61 User18 Map Created 05-05-2022 62 User18 Signed up 01-05-2022 63 User19 Field Created 02-05-2022 64 User19 Field Viewed 01-05-2022 65 User19 Map Recommended 02-05-2022 66 User19 Thanks in Advance
Suyog