Forum Discussion
Funnels with cumulative user count
Hi All, i have events dataset (example dataset below) Using this data set i have to create funnel visulization where i want to see how many users completed the process i.e from Signed u...
Anonymous
pls see the attachment below
ryan_mayu
Super User
Super UserAnonymous
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
- ryan_mayu
Anonymous
pls see the attachment below