Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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 ,
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 ,
This can be done using some visualizations combinations or charticulator maybe.
Can you share a sample example that I can download please?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHI @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?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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),..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |