Forum Discussion
Funnel from cummulative data
Hi Divous ,
If you can take your data in the following format:
Y Axis Bar Data Label Conv % Time Delta Dummy Bar Data/2 Type Users 900 msg 900 10 15 27 0 450 User Helpers 1000 msg 1000 9 25 43 0 500 Helper Users 1100 msg 1100 8 56 39 0 550 User "Dummy" is a computed column with all values 0.
"Bar Data/2" is a computed column with value Bar Data /2.
You can develop following visual using https://pbivizedit.com
You can take a look at https://pbivizedit.com/gallery/funnel
Please note, these visuals do not support (as on date):
1. native Power BI tooltips.
2. selection
Thanks,
-R
Hi Divous ,
So in the example you send out
Level 1 - 1 message
Level 2 - 2 Messages
Level 3 - 3 messages
Level 4 - 4 messages
MFelix
from picture is on every level just 1
from sheet is funnel:
Level 1 - Helper - 4
Level 2 - User - 3
Level 3 - Helper - 2
Level 4 - User - 2
It's about counting the helpers and users who wrote. Each time he writes, it's +1 to the appropriate funnel level. And they take turns and it doesn't matter if helper writes 5 messages before the user writes it to - for us it's like he wrote 1 (agregation).
Maybe it's unnecessarily complicated.. it was about knowing how far the communication would go - how many times they exchange messages (but it doesn't have to be the exact number of messages right in funnel just the number of "communication exchanges"). So in first level of funnel we can have 3000 messages/helpers who wrote, in second level there can by 2500 messages/users who wrote (respond), then 2000 messages/helpers who wrote (respond),..