Average days in Phase

[Priscila_Gr]

I have the tablex with the columns date (daily), name_id and phases. Each row corresponds a day, name_id and phase. I would like to create a measure that counts how many days on average a name_id stays in a phase (important to calculate just for the ones who have more than one phase registered).

In the sample bellow it should calculated for name_id  "d567" from the phase "Middle" until the first day "Premium" appears.

Thank you 

[FreemanZ]

hi @Priscila_Gr 

average can be very different. please help post some sample data with expected result to help those who might help you. 

[Priscila_Gr]

Thank you. I edited 

[FreemanZ]

hi @Priscila_Gr 

Great. And what about the result? How will it look like?

[Priscila_Gr]

In this case 2 days, so 2 as result. When I have several name_id that progressed badges the average time among them

[FreemanZ]

hi @Priscila_Gr 

not sure if fully get you, you may try to plot a visual with name and phase column with a measure like: