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
thanks for your response. I prepared simplified data
https://docs.google.com/spreadsheets/d/1QXiR-iV-NDBJYWyh-GAa8kUGfuA7LekLCRMBfbz1qus/edit?usp=sharing
Hi Divous ,
The file you share has in the previous post you have done is on read only I cannot copy the data or download it.
HI Divous ,
How are you calculating the different levels of the funnel? Is it based on the count of what columns?
In what column can I check for the aggregation and count?
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.