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 MFelix
its based on # of messages between helper and user, but sometime one of them can write more then one message so it need to be agregated.
So first level of funnel are every very first messages from helpers (after conneted to chat)
Second level of funnel are every very first messages from users
Third level of funnel are every second messages from helpers (after response from user)
Fourth level of funnel are every second messages from users (after response from helper)
Fifth level of funnel are every third messages from helpers (after respose from helper)
etc
I try to explain it on picture:
Agregation can be made probably only on "message from name" column because in this column we can see who wrote message.
There can also be small tricky part that user can write his/her very first message right after "helper conneted to chat" before helper.
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 - 2It'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),..