Calculate a drop out rate

Hi Anonymous,

According to your description, you want to get the give up visitors' count and rate, right?

If it is a case, you can refer to below formula to achieve your requirement.

Base table:

Table formula:

Datail Info =
var summary=SUMMARIZE('drop visit id',[Page],"FirstDate",MINX(FILTER(ALL('drop visit id'),[Page]=EARLIER([Page])),[DateID]),"LastDate",MAXX(FILTER(ALL('drop visit id'),[Page]=EARLIER([Page])),[DateID]),
"MinVisitors",MINX(FILTER(ALL('drop visit id'),[Page]=EARLIER([Page])),[visitors]),"MaxVisitors",MAXX(FILTER(ALL('drop visit id'),[Page]=EARLIER([Page])),[visitors]))

var detail=ADDCOLUMNS(summary,"FirstVisitors",MAXX(FILTER(ALL('drop visit id'),'drop visit id'[DateID]=EARLIER([FirstDate])&&'drop visit id'[Page]=EARLIER([Page])),[visitors]),"LastVisitors",MAXX(FILTER(ALL('drop visit id'),'drop visit id'[DateID]=EARLIER([LastDate])&&'drop visit id'[Page]=EARLIER([Page])),[visitors]))

return

SELECTCOLUMNS(detail,"Page",[Page],"FirstDate",[FirstDate],"LastDate",[LastDate],"FirstVisitor",[FirstVisitors],"LastVisitors",[LastVisitors],"MaxVisitors",[MaxVisitors],"MinVisitors",[MinVisitors],
"GiveUp(ByDate)",if([FirstVisitors]-[LastVisitors]>0,[FirstVisitors]-[LastVisitors],0),
"GiveUpRage(ByDate)",if([FirstVisitors]-[LastVisitors]>0,FORMAT(([FirstVisitors]-[LastVisitors])/[FirstVisitors],"Percent"),"0%"),
"GiveUp(ByAmonut)",[MaxVisitors]-[MinVisitors],
"GiveUpRage(ByAmonut)",if([MaxVisitors]>0,FORMAT(([MaxVisitors]-[MinVisitors])/[MaxVisitors],"Percent"),"0%"))

Regards

Xiaoxin Sheng