Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Divous
Helper III
Helper III

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.

Divous_0-1639499603816.png

 

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!

1 ACCEPTED SOLUTION
radhey_rec
Resolver II
Resolver II

Hi @Divous ,

If you can take your data in the following format:

 

Y AxisBar DataLabelConv %Time DeltaDummyBar Data/2Type
Users 900 msg9001015270450User
Helpers 1000 msg1000925430500Helper
Users 1100 msg1100856390550User

 

"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

radhey_rec_1-1640191218035.png

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

View solution in original post

9 REPLIES 9
radhey_rec
Resolver II
Resolver II

Hi @Divous ,

If you can take your data in the following format:

 

Y AxisBar DataLabelConv %Time DeltaDummyBar Data/2Type
Users 900 msg9001015270450User
Helpers 1000 msg1000925430500Helper
Users 1100 msg1100856390550User

 

"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

radhey_rec_1-1640191218035.png

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

MFelix
Super User
Super User

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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.

 

MFelix_0-1640081606345.png

 

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



@MFelixoh, sorry. Editing rights set.

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?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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:

Divous_0-1640162610440.png

 

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


Did I answer your question? Mark my post as a solution!

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),..

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.