Forum Discussion
Funnel from cummulative data
Hi community,
for our customers we provide chat and we need to know statistics.
I am looking for solution and nice and cozy visualization of chat progress. The goal is to have some kind of funnel which show how much users or helpers dont get to next chat message (next step) and how long it take.
The first measured message is after "%helper_name% connected to chat" and then count all that the user exchanges with the helper. If user or helper have more then one response/message, before other side respond, it can be agregated.
We are not interested in messages between chatbot and user, but how helpers and users (and how fast) respond. Or group of helpers or only one, but I think I should be done easily by filters.
Simplified sample data attached.
Picture attached for better understanding of my goal.
It can be done with PowerBI? I am trying to do it but still without success. Can you provide me with steps or functions which use to do it and some tip for visualization, please?
Thanks in advance!
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
9 Replies
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 ,
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
