TextColumn::make('leads_sum_connect_req')
->sum('leads', 'connect_req')
->summarize(Sum::make()->label('ConnctReq'))
->label('ConnctReq')
->description('ConnctReq'),
TextColumn::make('leads_sum_connected')
->sum('leads', 'connected')
->summarize(Sum::make()->label('Connected'))
->label('Connected')
->description('Connected'),
TextColumn::make('connected_percent')
->state(function($record){
return ( $record->leads_generated->sum('connected')) / ($record->leads_generated->sum('connection_request')+ .01) * 100;
})
->sortable()
->numeric(decimalPlaces: 1)
->summarize(
Summarizer::make()
->label('Connected %')
->using(function($record){ // , but [$record] was unresolvable.
return 99.9 ; // to test
return ( $record->leads_generated->sum('connected'))
/ ($record->leads_generated->sum('connection_request')+ .01) * 100;
})
)
TextColumn::make('leads_sum_connect_req')
->sum('leads', 'connect_req')
->summarize(Sum::make()->label('ConnctReq'))
->label('ConnctReq')
->description('ConnctReq'),
TextColumn::make('leads_sum_connected')
->sum('leads', 'connected')
->summarize(Sum::make()->label('Connected'))
->label('Connected')
->description('Connected'),
TextColumn::make('connected_percent')
->state(function($record){
return ( $record->leads_generated->sum('connected')) / ($record->leads_generated->sum('connection_request')+ .01) * 100;
})
->sortable()
->numeric(decimalPlaces: 1)
->summarize(
Summarizer::make()
->label('Connected %')
->using(function($record){ // , but [$record] was unresolvable.
return 99.9 ; // to test
return ( $record->leads_generated->sum('connected'))
/ ($record->leads_generated->sum('connection_request')+ .01) * 100;
})
)