% of conversions by number of months

[Anonymous]

Hi,

I have this visual that I would like to create, but can't seem to wrap my head around how to do this exactly. 

This is some sample dummy data:

Stage	Client	date	days since last stage	month  time
First	1	1/1/2020	0	1 month
First	2	1/2/2020	0	1 month
First	3	1/3/2020	0	1 month
First	4	1/4/2020	0	1 month
First	5	1/5/2020	0	1 month
First	6	1/6/2020	0	1 month
First	7	1/7/2020	0	1 month
Second	1	1/8/2020	7	1 month
Second	4	1/9/2020	5	1 month
Second	2	1/10/2020	8	1 month
Third	1	1/11/2020	10	1 month
Third	2	1/12/2020	10	1 month
Fourth	2	1/14/2020	12	1 month
Fourth	1	1/15/2020	14	1 month
Win	1	1/16/2020	15	1 month
Lost	2	1/17/2020	15	1 month
Second	6	2/4/2020	29	1 month
Third	6	3/1/2020	55	2 month
Fourth	6	3/23/2020	77	3 month
Lost	6	4/1/2020	86	3 month

I would like to create a visual that has the number of months on the x axis and then the conversion rate for each stage from the first as values. 

Thanks!

[Fowmy]

@Anonymous 

Not enough information to understand how you want to visualize your data. 
Refer to this video, https://www.youtube.com/watch?v=HXQCV0N4KWg

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Anonymous]

@Fowmy 

Thanks for sending that link, helped with the first part of my problem. Unfortunately the video is using one measure with a legend. I would like to use multiple measures without a legend. Can't seem to get any of my measures to work with that. I have linked the pbix file in a previous reply.

[amitchandak]

@Anonymous , do you have sequence number for these stages in this table of some other table

[Anonymous]

Hi @amitchandak ,

No reference to other tables ( except for calendar) as of right now. That could definitely be created.

the secuence of stages is:

1. First

2. Second

3. Third

4. Fourth

5. Either 'Win' or 'Lost'

[amitchandak]

@Anonymous , just give them number using switch or if and then try formula like this (New colum)

new column =
var _maxStf = maxx(filter(table, client =earlier([client]) && [stage] <earlier([stage No])),[stage No])
return
quotient(datediff( maxx(filter(table, client =earlier([client]) && [stage No] = _maxStf),[date]) ,[date],day),30)+1

You can append a month at the end

Stage No=

Switch([Stage],

"First",1,
"Second",2,
"Third",3,
"Fourth",4,
"Win",5,
"Lost",5)

[Anonymous]

Can't seem to get that to work.

I think my issue lies in that I have multiple measures that I would like to add in and neither works with this. Trying to get the percentage by time(number of months) of the conversion from first to second, third, fourth and Win. These measures are simply a divide by the number of rows for each stage.

This is a link to a pbix file where i have tried to do this unsuccessfully. The bottom graph is where I have included the measures.

https://ufile.io/kwlvp4n6

Thanks!